Hi Malini,
You might have to set the "Force to return SQL_WCHAR" for ADO/ODBC connection.
http://otn.oracle.com/products/oracle8i/htdocs/faq_combined1.html#ado
It would be best for you to set NLS_LANG to .UTF8 for ASP node.
Thanks,
----------
Shigé Takeda
Oracle Corporation
----- Original Message -----
From: "Amruthavakkula, Malini (CORP,Consultant)"
<[EMAIL PROTECTED]>
To: "Peter Linsley" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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,
| Malini.
|
| -----Original Message-----
| From: Peter Linsley [mailto:[EMAIL PROTECTED]]
| Sent: Wednesday, May 29, 2002 3:09 PM
| To: Amruthavakkula, Malini (CORP,Consultant)
| Cc: [EMAIL PROTECTED]
| Subject: Re: Japanese sites with shift-jis
|
|
| Malini,
|
| 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
| functions
| are being called etc.
|
| For more information take a look at the "Building Multilingual.." paper on
| the
| following site:
|
| http://otn.oracle.com/tech/globalization/content.html
|
| Regards,
|
| Peter
|
|
| 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
| are
| > 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
| >
|
|
