RE: SQL with special characters .. behaviour ?!

What do the execution plans look like in each case?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Prem Khanna J Sent: Wednesday, October 13, 2004 8:52 PM To: oracle-l_at_freelists.org
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