Doing SQL searches on accented characters

Here's how to force a collation type, in this particular case, it'll ignore case and accents when doing a search in MS SQL Server:

SELECT column1 FROM Table1
WHERE column1 = 'user' COLLATE SQL_Latin1_General_Cp850_CI_AI
ORDER BY column1 COLLATE SQL_Latin1_General_Cp850_CI_AI

An article on DBAzine.com goes into detail on this and has all the info you need. Also, be sure to check out the TSQL reference on COLLATION that would have been installed with the client tools.

Published July 19, 2004 · Updated September 17, 2005
Categorized as SQL
Short URL: http://www.livedjmix.com/s/178
久久中文字幕免费高清,三级在线看中文字幕完整版,中文字幕偷乱视频在线