Re: Globalisation, UTF8 and characters with Accent.
Hi Rick,
Thank you for your response. I *think* I have cornerd the porblem and found a solution.
I tried all combinations of encoding and collation on the DB. I had to change the collation at the Server, DB, Table & row level. Once I did it, I could insert the correct data when i copy-pasted it directly into the DB (via phpmyadmin). I have settled for "utf8-general-ci".
Now the data:
The data came in from an XML (which was ISO-8859-1 encoded). I was reading it via Perl and that was the main problem. It was messing up the characters. SO I tried using PHP and the same thing happened. I finally realised that the XML (though ISO-8859-1 encoded) was being read in using UTF-8 encoding. I had to then convert it from UTF-8 back to ISO-8859-1 and then inserted into the DB. I did it using the iconv() available for PHP and then inserted it into the DB. I have tried it for a small set of data on my local machine and it is working! Hope it works on the main server as well!
Thank you for the link. Will go through.
Regards,
R
Subject
Views
Written By
Posted
4263
August 15, 2011 02:09AM
1920
August 17, 2011 10:43PM
Re: Globalisation, UTF8 and characters with Accent.
2059
August 17, 2011 11:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.