Could not getConnection as before with Connector/J v3.0.13

2004-05-28 Thread michael_wu[]
Hi, I tried to use the latest jdbc driver v3.0.13. However, the program I coded no more work. It works well with v3.0.12. The new driver does not accept the following connect url string: jdbc:mysql://localhost/trdb?useUnicode=true&characterEncoding=UTF-8 The following exception occurs: ja

How to configure MySQLCC so that it can display utf8/utf16 string s correctly

2004-05-28 Thread michael_wu[]
Hi, I wrote an jdbc application and inserted strings data into the database. I can correctly selected them back. However, I can not visually see the data stored in the data through the MySQLCC GUI. Is there a way to explicitly specify the character set for MySQLCC? Any idea? Regards, Micha

Could not start MySQL after reinstall - Can't open privilege tabl es: Table 'mysql.host' doesn't exist

2004-05-27 Thread michael_wu[]
Hello, I run into a problem after re-installing mySQL 4.1.1 today. When I tried to start the service on my Windows2K, I got the following error: 040527 15:37:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist Can some one tell me how to solve the pro

FW: Re: FW: create database in specified character set

2004-05-25 Thread michael_wu[]
> -Original Message- > From: michael_wu[吳宏達] > Sent: Wednesday, May 26, 2004 9:12 AM > To: [EMAIL PROTECTED] > Subject: Re: FW: create database in specified character set > > Hi Hassan again, > Thanks for your kindly support. My program

FW: create database in specified character set

2004-05-25 Thread michael_wu[]
-Original Message- From: michael_wu[吳宏達] Sent: Tuesday, May 25, 2004 3:08 PM To: '[EMAIL PROTECTED]' 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 an

create database in specified character set

2004-05-24 Thread michael_wu[]
Hi, 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. Can anyone shed