View Single Post
Old 08-18-2008, 12:47 PM   #5 (permalink)
Speeple
The Wanderer
 
Join Date: Jan 2008
Posts: 21
Thanks: 0
Speeple is on a distinguished road
Default

That is due to folding and mapping of characters to a common derivative - which is normally a English-Latin characters (non-accented Latin) due to the dominance of English in programming implementations.

It normally makes sense to add folding, Google for example employ the technique also.

There might be a config option in MSSQL, but in MySQL it's an in-built feature.

For non-FT queries you can do a binary compare:

SELECT * FROM myTable WHERE BINARY title = 'Confederación';
__________________
AKA Martin Gallagher
Speeple is offline  
Reply With Quote