On Thu, Nov 15, 2001 at 12:21:19PM -0300, Walter D. Funk wrote:
> does anyone have a clue on how to manage japanese characters in a textfield
> in MySQL & PHP????
> it works on varchar type fields , defining it as binary; but no way to make
> it work in a text or blob field
 
You have to think in terms of the encoding used; you're probably accustomed
to ASCII and most Japanese encodings (including Shift-JIS) are 8-bit not
7-bit clean to represent the language fully.  Consider using something like
UTF-7 or binary fields with UTF-8 as your encoding.  The iconv functions
available in C and other languages should allow you to convert on-the-fly
between the various encodings.
-- 
Michael T. Babcock
CTO, FibreSpeed Ltd.

---------------------------------------------------------------------
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

Reply via email to