Sent: Tuesday, May 25, 2004 3:08 PM
Subject: RE: create database in specified character set
Many thanks! I had downloaded V4.1.1 and created a database in utf8
I successfully created a table and inserted rows of data with VARCHAR
columns into the table through the SQL pad.
With the Control Center GUI, I can see the result. It seems the data in the
table are right. I can see the multiple byte
characters in the varchar columns. However, when my application selected
data through JDBC, the returned strings are wrong.
Looks the returned strings are not in the right character set. Could some
one tell me what mistakes I had made?
From: Hassan Schroeder [mailto:hassan@stripped]
Sent: Tuesday, May 25, 2004 12:19 PM
Subject: Re: create database in specified character set
> I am evaluating the utf8 support of MySQL V4.0.18. I followed the
> documentation to create a database as the following:
> CREATE DATABASE trdb CHARACTER SET utf8;
> Strangely, I got syntax error(s). It seems that the reserved words
> CHARACTER SET are not recognized.
"As of MySQL 4.1.1, create_specification options can be given to
database characteristics. Database characteristics are stored in the
`db.opt' file in the database directory. The CHARACTER SET clause
That's "4.1.1" -- time to upgrade. :-)
Hassan Schroeder ----------------------------- hassan@stripped
Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1