Hi Takeda, We did set nls_lang=UTF8, but still we have problem. But does string function,server.HTMLencode work with Japanese charcters?
-----Original Message----- From: Shig� Takeda [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 4:03 PM To: Amruthavakkula, Malini (CORP,Consultant); Peter Linsley Cc: [EMAIL PROTECTED] Subject: Re: Japanese sites with shift-jis 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 | > | |
