onyourmark
asked on
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
"the b hakata";"16";"3";"駅ã«è¿
"the b hakata";"16";"3";"ã‚レã‚
Thanks.
Hotel.csv
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.