View Single Post
  #2 (permalink)  
Old June 14th, 2007, 11:11
ianlo ianlo is offline
Senior Member and Blogger
 
Join Date: Dec 2006
Location: Singapore
Posts: 141
Blog Entries: 5
Thanks: 5
Thanked 11 Times in 10 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
ianlo is on a distinguished road
Send a message via AIM to ianlo Send a message via Skype™ to ianlo
Re: CSV and UTF8 Encoding

Hi Kee,

If you are doing it on OTM 5.0, you should not be hitting this problem - Metalink is the next option. Otherwise if it is OTM 5.5 you are loading into then read on!

Yes you can load UTF-8 CSV files (in 5.0 and 5.5). However, are you doing this in Windows using Notepad or Excel? If you are, then you will have problems loading it into OTM 5.5 because Windows automatically pads the BOM characters (3 bytes) into the beginning of the file.

You need to strip the BOM characters first before loading the file via CSV upload.

I have been loading UTF-8 CSV files on 5.0 regularly so it should not be an issue but when we started using 5.5, the BOM gave us quite a bit of headaches.

Ps: I have passed a tool called Unicsved to Simon. This is a tool that will allow you to save unicode text files (tab delimited etc) to CSV format for loading

Last edited by ianlo : June 14th, 2007 at 11:33.