Problem with charsets

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
vvkkishore123
Forum Newbie
Posts: 1
Joined: Tue Oct 10, 2006 5:35 am

Problem with charsets

Post 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]
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I'm not absolutely sure what you're asking for help on.
Post Reply