You might have to set the "Force to return SQL_WCHAR" for ADO/ODBC connection.
It would be best for you to set NLS_LANG to .UTF8 for ASP node.
----- Original Message -----
From: "Amruthavakkula, Malini (CORP,Consultant)" <Malini.Amruthavakkula@corporate.ge.com>
To: "Peter Linsley" <firstname.lastname@example.org>
Sent: Wednesday, May 29, 2002 12:23 PM
Subject: RE: Japanese sites with shift-jis
| 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 [mailto:email@example.com]
| Sent: Wednesday, May 29, 2002 3:09 PM
| To: Amruthavakkula, Malini (CORP,Consultant)
| Cc: firstname.lastname@example.org
| 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 - 14:02:33 EDT