Need help: Storing non english char to SQL DB.

[Charles Katili]

Hi,

I have a problem on storing foreign char to SQL DB.

If user inputs a foreign char from asp page, for example, "ROSÉ", it
will be stored in the DB as "ROSé".

I need to be able to store as it is in the DB, "ROSÉ". The DB is ready
to store the string. I am able to store the string to the DB via other
mean (non GUI).

BTW, it is displayed properly in the Web GUI.


Thanks for any help that you can provide,
Charles

[Charles Katili]

Atrax,

I found the solution, although it was not obvious at first.

It turns out that web application uses UTF-8 encoding, and SQL uses UCS-2.
This different encoding standard caused the wrong data conversion.



Charles

Atrax <atrax@dontspamatrax.co.uk> wrote in message news:<ut5RhVAUDHA.560@TK2MSFTNGP10.phx.gbl>...

> well, first up the SQL field will need to be Nchar or NVarchar (or
> ntext). is it?
>
>
>
>
>
>
> ________________________________________
> Atrax. MVP, IIS
> [url]http://rtfm.atrax.co.uk/[/url]
>
> newsflash : Atrax.Richedit 1.0 now released.
> [url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!