Datbase accepting foreign letters?
View Single Post
08-18-2008, 12:47 PM
Join Date: Jan 2008
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';
View Public Profile
Send a private message to Speeple
Find More Posts by Speeple