Page 1 of 1

Problem with charsets

Posted: Tue Oct 10, 2006 5:43 am
by vvkkishore123
feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


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.  

DB Details:

Code: Select all

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.


feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]

Posted: Tue Oct 10, 2006 7:18 am
by feyd
I'm not absolutely sure what you're asking for help on.