From bigplanet34@hotmail.com Thu, 16 Aug 2001 09:10:19 -0700 From: "Big Planet" Date: Thu, 16 Aug 2001 09:10:19 -0700 Subject: characterset problem Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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