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