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,

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=truecharacterEncoding=UTF-8 The following exception occurs:

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

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

2004-05-27 Thread MICHAEL_WU
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 the MySQL process/user (sorry for not knowing

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
To: 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? This doesn't require

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 and inserted

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 now works. I post the source code

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