Eugene van den Hurk wrote:
> Hello,
>> Have a little bit more info. on this problem, which I should have
> included in my initial post...
>> The difference between versions of mysql on both servers are not that
> different:
> 3.23.58 - new server
> 3.23.52 - old server
> I got the status information when I logged into mysql on both servers,
> and it showed that they are both using the same character sets.
> Client characterset: latin1
> Server characterset: latin1
Sorry for the delay. I was sick yesterday.
Right you also mention that you read the mysql data using php and
apache. With apache 2 the default charset was set to utf-8 so maybe
this is your problem? There are loads of details here:
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=23692
In summary edit /etc/httpd/conf/httpd.conf and change the
AddDefaultCharset parameter appropriately.
--
Pádraig Brady - http://www.pixelbeat.org
--- Following generated by rotagator ---
#list internet services on a system
netstat -lp --inet
#list active connections to/from system
netstat --inet
--
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!