Encoding from utf-8 to SQL Latin1 General CP1 CI AS

[ac1982]

hi,

I would like your help on the following matter. I have a JavaScript file currently reading from another site xml file in (utf-8) and I would like to store those data in my database which is in SQL_Latin1_General_CP1_CI_AS. Is there any function in JavaScript that can encode (convert) text from utf-8 to SQL_Latin1_General_CP1_CI_AS or any other way to do that?

 

[BillyRayPreachersSon]

Personally, I'd do this server-side with a call to "iconv". If you don't have access to that, you could use something similar to this PHP function:

http://www.ustrem.org/en/articles/how-to-convert-between-utf8-cp1251-without-iconv-en/

You might even try to convert it into JavaScript if you absolutely must do this client-side.

Hope this helps,
Dan



Coedit Limited - Delivering standards compliant, accessible web solutions

Dan's Page [blue]@[/blue] Code Couch:

http://www.codecouch.com/dan/

Code Couch Tech Snippets & Info:

http://www.codecouch.com/