Re: Startin MySQL upon boot in Win2k

2001-08-22 Thread shiuwaitai
try mysqld-nt --install instead of your own batch script. After run the command, it will install mysql as NT/2000 service among user right. You can check it at Control Panel, System Admin Tool, Service to see its status. MySQL server will then run as a background service whenever restar

Re: SELECT COUNT(*) question ...

2001-08-21 Thread shiuwaitai
try in simple programming skill at 1) if your script language uses the pattern while (resultSet.next()) { out.println(resultSet.getFirstColumn(); ... ... ... counter++; } out.println("Total number of records"+counter); 2) if you do not want that, you can also try this sql

Re: Chinese PinYin/Traditional Support in mysql?

2001-08-16 Thread shiuwaitai
Hi, Have you tried to change your browser's encoding to Big5 in order to view Chinese characters? Have you tried to use mysql client to select those multi-byte characters? Have you seen they are OK? If you still cannot view strings properly, and you use Java to implement your system, try to fo

RE:Re: Localization..

2001-08-08 Thread shiuwaitai
Hi, try to use "varchar" or "varchar binary" instead. they work fine in my application for searching '%multibyte%multibyte%' condition even. >> Hi, >> >> >> >> I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as >> OS to run MySQL application. In my ex

Re: help please

2001-08-08 Thread shiuwaitai
try to download and install updated JDBC driver matching with your MySQL version and JDBC/JDK versions. - Original Message - From: "santosh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 08, 2001 4:07 PM Subject: help please > Hai all, > > I am using MySQL version

Re: Localization..

2001-08-08 Thread shiuwaitai
Hi, I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as OS to run MySQL application. In my experience, I have not changed charset parameter in server startup, database or column. They can store latin1 and big5 properly "in-a-mix". Have u tested to insert and select

Re: installing mysql

2001-07-27 Thread shiuwaitai
I dunt know MySQL's ini file. However, you have to copy a file "my-example.cnf" from your MySQL root directory to C:\ and then rename it as "my.cnf". Then edit the file C:\my.cnf . You modify paths in it by the "Escape format" like E:\\MySQL\\ . save it. open a new command prompt and change to

Re: java & mysql

2001-07-26 Thread shiuwaitai
In your Java app on Linux, change the db connection string to point to the old MySQL db server in Windows. For Linux, you can download MM JDBC driver from MySQL Contribution. Install and set-up by following the instruction. Set your dbURL = "jdbc:mysql://YOUR_WINDOWS_HOST_NAME/IP:3306/YOUR_DB_NA