mysql result has wierd encoding

Posted on 2011-05-04
Last Modified: 2012-06-21
I am doing a query into a mysql database that has both English, Japanese, and Chinese in it. The result set is all garbled for the non-English (see attached). Can anyone say how I can fix this so that the non-English is displayed properly (Japanese is displayed in Japanese characters and not like
"the b hakata";"16";"3";"駅に近くおしゃれなビジネスホテル";;"4";"4";"Feb 21, 2010"
"the b hakata";"16";"3";"キレイでシックな部屋";;"4";"4";"Feb 8, 2010"

Question by:onyourmark
    1 Comment
    LVL 39

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    This article describes some very basic things about SQL Server filegroups.
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now