Home > Archive > microsoft.public.sqlserver.server > August 2002 > Unicode





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Unicode
Brian

2002-08-02, 10:25 am

Can ayone please help with this problem, we have web application running in
a J2EE envronment and we are trying to place data into a table which could
be either standard ASCII characters or Japanese UTF-8 characters.

The column datatypes are NVARCHAR, however, if I use EM and paste the
Japanese text directly into the table and I then view this data on my web
page, all the text appears just fine BUT if the data is enterd via a stored
procedure which is executed via a JSP page, the Japanese data gets
corrupted.

This is driving me crazy, does anyone have any pointers as to what is going
on, I have tried the jdbcdriver group but there's not much activity in there


I hope someone can help with this...

Thanks in advance
Brian


Brian

2002-08-02, 10:25 am

Sorry, forgot to mention we are running SQL 2000

"Brian" <bford@markem.com> wrote in message
news:#9D1gAjOCHA.1788@tkmsftngp08...
> Can ayone please help with this problem, we have web application running

in
> a J2EE envronment and we are trying to place data into a table which could
> be either standard ASCII characters or Japanese UTF-8 characters.
>
> The column datatypes are NVARCHAR, however, if I use EM and paste the
> Japanese text directly into the table and I then view this data on my web
> page, all the text appears just fine BUT if the data is enterd via a

stored
> procedure which is executed via a JSP page, the Japanese data gets
> corrupted.
>
> This is driving me crazy, does anyone have any pointers as to what is

going
> on, I have tried the jdbcdriver group but there's not much activity in

there
>
>
> I hope someone can help with this...
>
> Thanks in advance
> Brian
>
>



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net