Thread: Utf8

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2010
    Posts
    76
    Rep Power
    5

    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?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    205
    Rep Power
    15
    Originally Posted by derstauner
    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

IMN logo majestic logo threadwatch logo seochat tools logo