unicode from db to text area?

[guineamation]

when i open a recordSet and insert the data into a text area in a form on a web page, i get the actual unicode characters ó instead of the special character it represent.

how can i show the decoded text on the text area?

 

[MakeItSo]

I suppose you have encoded with Server.HTMLencode before writing to the DB?

Try using the unescape function:

response.write unescape(rs("yourfield"))

[blue]An eye for an eye only ends up making the whole world blind. - "Mahatma" Mohandas K. Gandhi[/blue]

 

[guineamation]

Hi, well... it turns out that i had a problem with just some of the records, most of the records turn out just fine without using the unescape.
but i needed it anyways so thanks!