Foreign characters gibberish after dist upgrade

Discussion in 'MySQL' started by pig2cat, Oct 24, 2010.

  1. #1
    Hi,

    Last week I upgraded from Debian 4 to Debian 5, all seemed to have gone well except that foreign characters show up as gibberish. (used to show properly)
    example: http://piggymoo.com/forum/nodame-ca...o-a-sup3-a-iquest-a-frac14-a-a-not-t5330.html
    Nodame Cantabile (のだめカンタービレ) should be Nodame Cantabile (のだめカンタービ)

    Also in phpmyadmin this shows up as gibberish.

    For all new posts(posted after updating) the foreign characters work normally...

    phpinfo: http://piggymoo.com/phpingo.php

    I have no idea why this happened, I expect it could be a php issue so I'd be grateful if anyone can help figuring out why this happend.
     
    pig2cat, Oct 24, 2010 IP
  2. redditor

    redditor Guest

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    This is an Apache issue... Go to your httpd.conf file and change...

    AddDefaultCharset UTF-8
    to
    AddDefaultCharset Off
     
    redditor, Nov 6, 2010 IP
  3. pig2cat

    pig2cat Active Member

    Messages:
    299
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    60
    #3
    Hi,
    Thank you for your suggestion, it got me on the right path!
    I do not run apache, but nginx with php5-fpm
    I changed the default charset in php5 to UTF-8 (it was on off) after some trying
    and it worked!

    Many thanks!
     
    pig2cat, Nov 6, 2010 IP