Unicode conversion

[Rob]

Hello

I am experiencing a problem in developing an ASP.NET application which
will run in tandem with an existing "classic" ASP app. Some users of
the ASP app are entering text in their native languages (japanese and
chinese) using native code pages (eg Big5 and shift_jis). The
webserver and SQL server are both english. The problem is that for our
ASP.NET app we want all text stored on the DB (nvarchar) as unicode,
but the ASP app writes the data as a unicode reprentation of the
native code page, and not as the actual . For example, if a single
japanese character, say unicode char 39640, is captured via a textbox
on an ASP page, the resulting string, although it is unicode, contains
the two bytes 130 and 141 which are the 2 bytes of the shift_jis
codepage which map to the unicode char 39640, resulting in incorrect
(from our ASP.NET apps point of view) storage on in the db.

So, my question is: how in vbscript/ASP/ADO can we take the text from
a standard html text box encoded in its native code page and convert
that to unicode for storage on the db ?

Thanks in advance
Rob

[Rob]

Hello, can anyone offer any advice on this ?

> Hello
>
> I am experiencing a problem in developing an ASP.NET application which
> will run in tandem with an existing "classic" ASP app. Some users of
> the ASP app are entering text in their native languages (japanese and
> chinese) using native code pages (eg Big5 and shift_jis). The
> webserver and SQL server are both english. The problem is that for our
> ASP.NET app we want all text stored on the DB (nvarchar) as unicode,
> but the ASP app writes the data as a unicode reprentation of the
> native code page, and not as the actual . For example, if a single
> japanese character, say unicode char 39640, is captured via a textbox
> on an ASP page, the resulting string, although it is unicode, contains
> the two bytes 130 and 141 which are the 2 bytes of the shift_jis
> codepage which map to the unicode char 39640, resulting in incorrect
> (from our ASP.NET apps point of view) storage on in the db.
>
> So, my question is: how in vbscript/ASP/ADO can we take the text from
> a standard html text box encoded in its native code page and convert
> that to unicode for storage on the db ?
>
> Thanks in advance
> Rob

[Bob Barrows]

Rob wrote:

> Hello, can anyone offer any advice on this ?
>

>> Hello
>>
>> I am experiencing a problem in developing an ASP.NET application
>> which will run in tandem with an existing "classic" ASP app. Some
>> users of the ASP app are entering text in their native languages
>> (japanese and chinese) using native code pages (eg Big5 and
>> shift_jis). The webserver and SQL server are both english. The
>> problem is that for our ASP.NET app we want all text stored on the
>> DB (nvarchar) as unicode, but the ASP app writes the data as a
>> unicode reprentation of the native code page, and not as the actual
>> . For example, if a single japanese character, say unicode char
>> 39640, is captured via a textbox on an ASP page, the resulting
>> string, although it is unicode, contains the two bytes 130 and 141
>> which are the 2 bytes of the shift_jis codepage which map to the
>> unicode char 39640, resulting in incorrect (from our ASP.NET apps
>> point of view) storage on in the db.
>>
>> So, my question is: how in vbscript/ASP/ADO can we take the text from
>> a standard html text box encoded in its native code page and convert
>> that to unicode for storage on the db ?
>>
>> Thanks in advance
>> Rob

It's the weekend here, so many of us aren't areound as much as we are during
the week. Be patient.

Unfortunately, I don't know the answer to your question. Have you tried
asking on one of the dotnet newsgroups?

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Rob]

Hello ! ! !

Can anyone help with this ? I have tried on the dotnet groups, but it
seems to be specifically an issue with ASP, and since I know little
about ASP, any advise would be very welcome.

Thanks
Rob

> Rob wrote:

> > Hello, can anyone offer any advice on this ?
> >

> >> Hello
> >>
> >> I am experiencing a problem in developing an ASP.NET application
> >> which will run in tandem with an existing "classic" ASP app. Some
> >> users of the ASP app are entering text in their native languages
> >> (japanese and chinese) using native code pages (eg Big5 and
> >> shift_jis). The webserver and SQL server are both english. The
> >> problem is that for our ASP.NET app we want all text stored on the
> >> DB (nvarchar) as unicode, but the ASP app writes the data as a
> >> unicode reprentation of the native code page, and not as the actual
> >> . For example, if a single japanese character, say unicode char
> >> 39640, is captured via a textbox on an ASP page, the resulting
> >> string, although it is unicode, contains the two bytes 130 and 141
> >> which are the 2 bytes of the shift_jis codepage which map to the
> >> unicode char 39640, resulting in incorrect (from our ASP.NET apps
> >> point of view) storage on in the db.
> >>
> >> So, my question is: how in vbscript/ASP/ADO can we take the text from
> >> a standard html text box encoded in its native code page and convert
> >> that to unicode for storage on the db ?
> >>
> >> Thanks in advance
> >> Rob

>
> It's the weekend here, so many of us aren't areound as much as we are during
> the week. Be patient.
>
> Unfortunately, I don't know the answer to your question. Have you tried
> asking on one of the dotnet newsgroups?
>
> Bob Barrows