February 13th, 2013, 01:56 AM
Originally Posted by derstauner
I'm hungarian and I create a database with utf8 charset.
And I cannot select values with the where clause, like this "where field1='anyád'
your database charset
client side charset
should all be set to UTF8, otherwise there might be decoding incompatibilities.
if your database is set to utf8 and you have your "anyád" there (where á has code of 0225)
when you are looking for your "anyád" but asking in ASCII charset (where á has code of 160) then
anyád is not equal to anyád
probably one of the three is not set properly to UTF8