On Friday 14 September 2001 12:43, Steve McKeogh wrote:
> How do I get Japanese text to be inputted into a mySQL database and get to
> pull out correctly on the page.
>
> I've tested it already by inserting some dummy Japanese text and it inputs
> itself into the database as complete jibberish. How can I solve this?
Well, that's the first time I've ever heard of self-inserting Japanese text.
If all my other data would do that ;-)
AFAIK vanilla MySQL does not have any problems with 2-byte character data,
even in CHAR/VARCHAR fields. You might want to find out whether your server
was compiled with a specific character set. I have worked with native
Japanese encodings and UTF8 in MySQL several times and any problems have been
with the pre- and post-processing outside of MySQL.
As you don't say what kind of Japanese text (EUC? JIS? SJIS? Unicode?) you
are storing, and what method(s) you are using to store and retrieve it, it's
hard to provide a solution...
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a MySQL database is more fun than eating spam"
---------------------------------------------------------------------
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
