Hey guys,
I just upgraded to mysql 4.1 and I'm trying to get damn unicode to work in
my database. I put "default-character-set=utf8" in my my.cnf file and
restarted the database. Then I created a brand new database new table, new
field. I try hooking into the newly created database with Mysql Control
Center or MS-Access using myODBC driver. When i try to type in an extended
character set in a field (either in chinese or hebrew or whatever) and close
and open the table, all I see are question marks!
Does anyone know what's going wrong? I am able to see Hebrew and Chinese
characters fine on my computer through my web browser, why isn't it storing
in the database correctly? I even did a "SELECT HEX(your_column) FROM
your_table;" and I see the hex codes of questions marks and not the unicode
characters of what I typed.
- Steve
