Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> characterset problem

characterset problem

From: Big Planet <bigplanet34_at_hotmail.com>
Date: Thu, 16 Aug 2001 09:10:19 -0700
Message-ID: <F001.0036D578.20010816091256@fatcity.com>

Hi there , We have UTF-8 database. We are using OAS with UTF-8 setting and java at front end connects to OAS socket to send data to be inserted into oracle .Is it required to convert data send by Java to be converted to UTF8 ?  OAS (OAS NLS_LANG=AMERICAN_AMERICA.UTF8)When we send some particuler chinese characters into database I get weired results .As shown below . Does it mean 4+2 =5 ?? or I am doing something wrong here . select lengthb(casename), lengthb(caseName||'XX') , lengthb('XX') from case where casepin=736; LENGTHB(CASENAME)

LENGTHB(CASENAME||'XX') LENGTHB('XX') ------------------- 
------------------------- ------------- 
4                                   

 5      2 Thanks , AJ Received on Thu Aug 16 2001 - 11:10:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US