Re: [PHP] Japanese entry into MySQL and into emails

From: Marek Kilimajer (kilimajer_at_webglobe.sk)
Date: 10/30/03 

Date: Thu, 30 Oct 2003 13:26:13 +0100
To: Dave G <ml@autotelic.com>, PHP <php-general@lists.php.net>

Please, include the list's address in cc. You will have much higher
chance to get an answer.

Dave G wrote:
> With regards to the kanji field in the MySQL database:
> Only one field in one table uses kanji. There are seven other
> tables. Will setting the character set to charset=ISO-2022-JP have any
> impact on all the straight English input in the database?
>

As I suppose kanji contains also the latin alphabet with the same
character codes as ascii, it will not. But you might have trouble
searching on the column (case folding according to latin1). Mysql can be
configured to use other encodings but the change is server wide and you
are on a shared host. I think you should set the column type to BLOB, no
text transformation takes place in this case.