problem with charset

[vvkkishore123]

hi All,

I am develpoing web pages which support i18n. My database is Mysql and it's charset is shift_jis. when I tried to display the data in the browser by reading from DB using php functions mysql_connect() & mysql_fetch_row(), data gets displayed in UTF 8 encoding. :mad:

DB Details:
mysql> show variables like '%char%';
+--------------------------+-----------------------------------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | sjis |
| character_set_results | sjis |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /home/intlmysql/working/mysql/share/mysql/charsets/ |
+--------------------------+-----------------------------------------------------+
7 rows in set (0.00 sec)

Please help me.

Thanks in advance,
Kishore.

[MarkR]

I think you really need to be doing "SET NAMES utf8" if you're using UTF8.

Otherwise you'll run into trouble.

Why not use utf8 for the tables as well? That will give you the ability to store more characters than sjis (I think??) and it's more standard.

Mark

[vvkkishore123]

Hi Mark,

Thanks for your response.
Actually I am planning to support other i18n languages like spanish,dutch, korean .... In that case I will have separate databases in mysql.

Thanks,
Kishore.

[vvkkishore123]

Hi Mark,

One more thing is for all the charsets the web pages are the same. Right now in the design, we donnot know which request belongs to which charset.

Thanks,
Kishore.

[MarkR]

If you are planning to make a multilingual site, you should use utf8 throughout. Otherwise, you'll just get really, really confused.

There is no non-unicode character set which includes all the characters you're talking about.

Unless you are superhuman, you will fail to make a site which uses multiple character sets. Don't do it. Use utf8 for the input, output, database and everything else.

If you're going to have several languages in the database- great, but do it in utf8, PLEASE!

Mark

[vvkkishore123]

sounds good.
Thanks Mark.

Kishore.