Hi there,
I have Mysql 4.1.1 runing on Redhat Linux 9, both of them are English Version.
Now, I need a table which my user can input both Chinese and English, so I create a DB as following:
DROP database IF EXISTS user;
CREATE DATABASE IF NOT EXISTS user CHARACTER SET utf8;
use user;
DROP TABLE IF EXISTS password;
CREATE TABLE password ( customerid CHAR(20) NOT NULL, password CHAR(50) not null, role CHAR(10) DEFAULT 'customer', PRIMARY KEY (customerid) );
I can input Chinese character, but, when I retrieve the table, the character looks like question marks.
Is some thing wrong with server side? How can I fix it? My mysql server info as following, any helps are appreciated.
Arthur Niu
---------------------------------------------------------------------------------------------------------------------------------------
mysql Ver 14.3 Distrib 4.1.1-alpha, for pc-linux (i686)
Connection id: 2 Current database: mysql Current user: [EMAIL PROTECTED] SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 4.1.1-alpha-standard Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1_swedish_ci Server characterset: latin1_swedish_ci UNIX socket: /var/lib/mysql/mysql.sock
_________________________________________________________________
MSN Premium helps eliminate e-mail viruses. Get 2 months FREE* http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
