08-18-2008, 12:47 PM
|
#5 (permalink)
|
|
The Wanderer
Join Date: Jan 2008
Posts: 21
Thanks: 0
|
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';
|
|
|
|