it's true that mysql-4.x process binary data well when not using multi-byte charset but mysql-4.x process it differently when using multi-byte it's only for GBK text escaping, which is not suitable for binary data
that's the key point if u don't use multi-byte, and mysql-4.x, u will never have such problem >From: Gerald Clark <[EMAIL PROTECTED]> >To: xuefer tinys <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: MySQL-4.x GBK Problem with Binary Data >Date: Fri, 20 Sep 2002 15:35:20 -0500 > >Binary data is binary data. >It doesn't mattrer whether it is GBK or and audio file, >or a jpeg. >If you escape the data properly before inserting it you will get >back the same data you stored. > >Your application must display it properly. > >xuefer tinys wrote: > > > re-posting multibyte problem. > > > > does anyone have problem with binary data in MySQL-4.x using GBK > > charset or any other multibyte charset? > > inserting/updating/replacing > > > > the full description is in mysql mailing list archive, sent by me > > will not repost full desc until someone have or care this problem > > > > thx > > > > _________________________________________________________________ > > 与联机的朋友进行交流,请使用 MSN Messenger: > > http://messenger.microsoft.com/cn/ > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _________________________________________________________________ 享用世界上最大的电子邮件系统— MSN Hotmail。http://www.hotmail.com/cn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php