Results 1 to 3 of 3
  1. #1

    Question Mysql Unicode Corrupted


    I was using mysql 4.0.x and recently i upgraded mysql to 4.1.x

    Previously on one of my client's database used to store the unicode characters in its table and those characters were properly fetched and displayed in website by php. After I upgraded the mysql those unicode character suddenly corrupted and now showing some weired characters. How do i recover from this?


  2. #2
    Join Date
    Mar 2003
    Have you tried adding the following to your /etc/my.cnf:

    init-connect=SET NAMES binary

    Then restart MySQL... that should fix the ???'s showing up after upgrading to 4.1.x.
    Patrick William | RACK911 Labs | Software Security Auditing
    400+ Vulnerabilities Found - Quote @ - Security notices for the hosting community.

  3. #3
    Hello Pat,

    Thanks for your help.

    Now, the error that was occured which fetching the unicode fields from mysql database by php no longer exists while using your tip. However, the unicodes are still correpted. ie. the characters are still like

    "पà¥à¤°à¤¾à¤µà¤¿à¤§à¤¿à&#16 4;• तथा वà¥à¤¯à¤¾à¤µà¤¸à¤¾à¤¯à&#164 ;¿à¤• "

    seems like these unicode characters are corrupted. anyway to recover them?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts