View Single Post
  #5 (permalink)  
Old June 18th, 2007, 03:02
engyeowkee engyeowkee is offline
Junior Member
 
Join Date: May 2007
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
engyeowkee is on a distinguished road
Re: CSV and UTF8 Encoding

Hi Ian,

Perhaps i'm not using the tool correctly as I'm not able to preserve the the chinese char despite encoding it in UTF-8 w/o BOM, below is the process I went thru,

1. Save LOCATION.txt (exported from OTM) in as text file UTF-8 using Notepad
2. Open LOCATION.txt using uniCSVed and encode it in UTF-8 wo BOM, save it as a CSV file.
3. Open the LOCATION.csv file in Excel to add/format data to be uploaded
4. Save the LOCATION.csv in Excel (all chinese char turn into after the save)

Any thoughts/suggestions, thanks!

kee