Welcome to WebmasterWorld Guest from 54.145.55.135

Forum Moderators: phranque

Message Too Old, No Replies

ActiveXObject("ADODB.Command") data encoding problem

     
10:16 am on Jan 27, 2010 (gmt 0)

New User

10+ Year Member

joined:Oct 19, 2005
posts: 34
votes: 0


hi,

i currently have a JavaScript executable file that uses ActiveXObject("Microsoft.XMLDOM") to read an xml file. All the information that i get is in utf-8. When i tried to save those data into my database, is not stored correctly and all the characters are wrong. I have check my database and I found that the collation is SQL_Latin1_General_CP1_CI_AS. For storing the data into db i use
ActiveXObject("ADODB.Command"). Is there is property for this object to set the charset from utf-8 to SQL_Latin1_General_CP1_CI_AS?

thank you