first make sure that you are using a character set in the browser that
supports the characters. Then make sure that you are using a code page in
ASP that supports them as well. Simplest way is to use UTF-8
in ASP script
Session.Codepage=65001
then send to browser:
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
Now you should see the same characters back when you write the SQL statement
back.
Now you need to get the data into the database. If you have SQLServer set to
a collation that supports your characterset then it should work now. If not,
you will need to use NCHAR or NTEXT columns. Either use a parameterized
command object or when building dynamic SQL prefix the data string with "N"
to tell SQLServer that the data is unicode.
--
--Mark Schupp
"hilio" <hi***@cambridgesoft.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
Aaron, thanks for the suggestion. I tried response.write and it
displayed different characters, not the characters that are entered by
the user. Would this indicate that the web server is not interpreting
the characters correctly?