I have a strange issue which is killing me.
I have a CSV file that is UTF-8. It is made up of some text fields and numeric fields. When I open the file in Notepad/Notepad++ and try to add Arabic text to it, it behaves very strange. An extract of the text is below:
When I try to add arabic text after Jeddah in the same field it works fine, but only because the field after is also a text field.
14602,Jeddah / تاريخ,Project#1,62370.00,210000.00,Credit,
But when I try to add arabic text after Project#1, it automatically moves the arabic text to the beginning of the next text field
14602,Jeddah / تاريخ,Project#1 / تاريخ,62370.00,210000.00,Credit,
Does anyone know what the heck is going on? I am trying to load data into a DB after i insert the arabic, but this is making it impossible...