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" <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > __________________________________________________________________ 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
