RE: SQL with special characters .. behaviour ?!

What do the execution plans look like in each case?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Prem Khanna J
Sent: Wednesday, October 13, 2004 8:52 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: SQL with special characters .. behaviour ?!


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

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

the predicate part has something like=20

"AND papr.payroll_name =3D 'AA=81QPTEST=81QB'"


Note that the underscore =81Q above is a double byte character.=20

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

whereas when i change the predicate part to=20

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

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

the database character set is JA16SJIS.=20

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

Regards,=20
Prem.=20
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: