Character set differs in reality
Posted by:
na na
Date: October 19, 2010 02:38PM
Hi Folks,
I have a really wierd situation - here are the details from our server when I run SHOW VARIABLES LIKE 'character_set%'.
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
Here's what I get when I make a connection with PHP (through either Zend or ADODB - so clearly generic):
character_set_client, latin1
character_set_connection, latin1
character_set_database, latin1
character_set_filesystem, binary
character_set_results, latin1
character_set_server, utf8
character_set_system, utf8
character_sets_dir, /usr/share/mysql/charsets/
Obviously I can run SET NAMES but I'm 100% confused why the server is differing to what I'm given in PHP??
The key issue being that text is encoding wrongly and giving funny characters when going into our live database and giving the funny <?> when coming out.
Any help would be grand.
Thanks
A
Edited 1 time(s). Last edit at 10/19/2010 02:44PM by na na.
Subject
Views
Written By
Posted
Character set differs in reality
3292
October 19, 2010 02:38PM
1333
October 20, 2010 08:27PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.