Utf8

Hi,

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'


Why?

Szia,

your database charset
+
field charset
+
client side charset

should all be set to UTF8, otherwise there might be decoding incompatibilities.


example:
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


Udv,
Szilvi