RE: Japanese sites with shift-jis

From: Amruthavakkula, Malini (CORP,Consultant) (
Date: Wed May 29 2002 - 15:23:30 EDT

Hi Peter,

We use oracle drivers for ODBC on webserver which is IIS5.0.

Once the data is inserted in database and when we fetch back and look for
string length using ln() function in the ASP Page, it doesn't give us the
right output. Eventhough the characters stored are three, it shows the
string lenth as six. Also it doesn't work with mid(),split() functions.

Thanks in advance,

-----Original Message-----
From: Peter Linsley []
Sent: Wednesday, May 29, 2002 3:09 PM
To: Amruthavakkula, Malini (CORP,Consultant)
Subject: Re: Japanese sites with shift-jis


There is no difference between Oracle on NT and Oracle on Solaris as far as
database character encoding support is concerned. It would be interesting
to know more about your scenario such as where the string manipulation
are being called etc.

For more information take a look at the "Building Multilingual.." paper on
following site:



On Wed, 29 May 2002, Amruthavakkula, Malini (CORP,Consultant) wrote:

> Hi All,
> we are in the process of launching a website in Japanese. We are using
> charset in all our ASP pages to shift-jis.
> Data insertion and retrieval goes fine, but the regular string function
> not giving proper results with the data inserted in database.
> We use oracle8i with charset = utf-8. Also server.HTMLencode doesn't work.
> Our database is running on Solaris.
> Does it make any difference whether the database is on NT or Solaris.
> Any experience with this kind of set up for website, pls. reply back,
> looking forward for more suggestions.
> Thanks

This archive was generated by hypermail 2.1.2 : Wed May 29 2002 - 13:38:37 EDT