List:General Discussion« Previous MessageNext Message »
From:michael_wu[吳宏達] Date:May 25 2004 7:10am
Subject:FW: create database in specified character set
View as plain text  

-----Original Message-----
From: michael_wu[吳宏達] 
Sent: Tuesday, May 25, 2004 3:08 PM
To: 'mysql@stripped'
Subject: RE: create database in specified character set


Many thanks!  I had downloaded V4.1.1 and created a database in utf8
character set.
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?
Regards,

-----Original Message-----
From: Hassan Schroeder [mailto:hassan@stripped]
Sent: Tuesday, May 25, 2004 12:19 PM
To: mysql@stripped
Subject: Re: create database in specified character set


michael_wu[吳宏達] wrote:

>      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.

<http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html>

    "As of MySQL 4.1.1, create_specification options can be given to
specify
     database characteristics. Database characteristics are stored in the
     `db.opt' file in the database directory. The CHARACTER SET clause
     specifies ..."

That's "4.1.1" -- time to upgrade. :-)

HTH!
-- 
Hassan Schroeder ----------------------------- hassan@stripped
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                          dream.  code.




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
Thread
FW: create database in specified character setmichael_wu[吳宏達]25 May
  • Re: FW: create database in specified character setHassan Schroeder25 May