[qmailadmin-cvs] qmailadmin adduser chinese character into mysql5 rafferty (SOS)

[<am...@si...>]

qmailadmin team:
                       How are you!
      environment:
OS: uname -a
Linux rhce4test 2.6.9-5.EL #1 Wed Jan 5 19:22:18 EST 2005 i686 i686 i386 GNU/Linux
more  i18n
LANG="en_US.UTF-8"
SUPPORTED="en_US.UTF-8:en_US:en"
SYSFONT="latarcyrheb-sun16"
-------------------------------------------------------
locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
Mysql version : 5.0.27
| character_set_client | gbk   | 
| character_set_connection | gbk   | 
| character_set_database | gb2312 | 
| character_set_filesystem | binary | 
| character_set_results | gbk   | 
| character_set_server | gb2312 | 
| character_set_system | utf8  | 
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ | 
qmailadmin version : 1.2.11
./configure --with-htmllibdir=/home/apache/cgi-bin/qadm \
--enable-cgibindir=/home/apache/cgi-bin \
--enable-qmaildir=/var/qmail --enable-autoresponder-bin=/usr/local/bin \
--enable-ezmlmdir=/usr/local/bin/ezmlm --enable-htmldir=/home/apache/htdocs \
--enable-vpopmaildir=/home/vpopmail --enable-vpopuser=vpopmail --enable-vpopgroup=vchkpw \
--enable-autoresponder-bin=/usr/local/bin/ --enable-maxusersperpage=20 \
--enable-maxaliasesperpage=20 --enable-domain-autofill --enable-modify-quota \
--enable-modify-spam --enable-help --disable-ezmlm-mysql
 
OS Charset is  UTF-8 ; 
if compile mysql with --with-charset=UTF-8 then table vpopmail column pw_gecos can't insert chinese character value. English character can insert.
if compile mysql with --with-charset=gb2312 or --with-charset=gbk then table vpopmail column pw_gecos can insert value , but chinese character is rafferty .all is ????
 
Please help me work this problem out . Thank you very much .
 Sincerely Thanks!


新浪空间——与朋友开心分享网络新生活！

-------------------------------------------------------------------
新浪空间——与朋友开心分享网络新生活！(http://space.sina.com.cn/ )