• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 414
  • 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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