one has to encode "extend string or any unicode" to utf-8 first and then insert it to
MySQL database 4.1
Most likely you did not encode them to utf-8.
zhi peng
"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
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
Netscape. Just the Net You Need.
New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp
