• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

mysql result has wierd encoding

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"

Thanks.
Hotel.csv
0
onyourmark
Asked:
onyourmark
1 Solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now