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

[Tom C. <to...@to...>]

Please join the qmailadmin user mailing list (email qmailadmin- 
sub...@in... to subscribe) and try asking your question there  
(by emailing qma...@in... after you've subscribed).

-Tom

On Nov 10, 2008, at 12:20 AM, am...@si... wrote:
> 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!
>
>
> 新浪空间——与朋友开心分享网络新生活！
>
> 新浪空间——与朋友开心分享网络新生活！
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/ 
> _______________________________________________
> qmailadmin-cvs mailing list
> qma...@li...
> https://lists.sourceforge.net/lists/listinfo/qmailadmin-cvs