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

Home -> Community -> Mailing Lists -> Oracle-L -> SQL with special characters .. behaviour ?!

SQL with special characters .. behaviour ?!

From: Prem Khanna J <premj_at_rediffmail.com>
Date: 14 Oct 2004 00:52:05 -0000
Message-ID: <20041014005205.26423.qmail@webmail10.rediffmail.com>


Hi all,
the env is oracle 9.2.0.4/Aix 5.2L.

I find something strange with a query.it joins 11 tables .

the predicate part has something like

"AND papr.payroll_name = 'AAQPTESTQB'"

Note that the underscore Q above is a double byte character.

the PAPR table has 2 records for the
value 'AAQPTESTQB'. This query takes a long time and waits indefinitely for 'direct path write' event.

whereas when i change the predicate part to

"AND papr.payroll_name like 'AA%PTEST%B'"

the response is instantaneous.I have replaced the underscore with "%" and used LIKE operator.

the database character set is JA16SJIS.

I wonder why it happens so ? Have anyone faced such issues while working with multibyte charcters.

Regards,
Prem.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 13 2004 - 19:47:54 CDT

Original text of this message

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