Re: Unicode characters are giving me question marks

[Gleb Paharenko]

Hello.

Use MySQL Query Browser instead of MySQL CC. What output does the
following statement produce:

 show variables like '%char%';



"Steve Quezadas" <steve@stripped> wrote:
> 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
> 
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com