Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> characterset problem
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
![]() |
![]() |