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

RE: FW: Could not start MySQL after reinstall - Can't open privil ege tables: Table 'mysql.host' doesn't exist

2004-05-27 Thread MICHAEL_WU
: MICHAEL_WU Cc: [EMAIL PROTECTED] Subject: Re: FW: Could not start MySQL after reinstall - Can't open privilege tables: Table 'mysql.host' doesn't exist Did you change the permissions for the files to include read/write/change for the user/account MySQL uses on your system? T

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

2004-05-27 Thread MICHAEL_WU
ursday, May 27, 2004 4:52 PM To: "michael_wu[¡±d¡±?1F]" Cc: [EMAIL PROTECTED] Subject: Re: Could not start MySQL after reinstall - Can't open privilege tabl es: Table 'mysql.host' doesn't exist Check permissions on the mysql\data directory and files/folders below for

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