Problem with charset

[SuperMoonster]

Hello everyone,

I am inserting values in a database through asp and setting the charset like this:

SESSION.LCID = 1049

I need this LCID because the page will insert chars in portuguese, with accentuation.

So, I get my string with:
nome = Trim(Request.Form("txtNome"))

And if I do a response.write, it will be ok. If my string is "João", it will come with the right chars.

Then, I create the sql string, inserting this name. I do a response.write, and again, it prints fine.

But when I execute the insert, the string that went to the database is like: "João"

It is NOT a database problem, because if I execute the same insert in the database tool, it inserts correctly. So I figure it is only correct for the display, not inside.

Can anyone help?

 

[gmmastros]

I'm thinking that the problem is (probably) occurring during the actual insert in to the database. As such...

1. What type of database are you using?
2. Can you show the ASP code you use to insert the data in to the database?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Sheco]

Perhaps a unicode datatype is required for storing characters in this language?