RE: SQL with special characters .. behaviour ?!
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <premj@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 14 Oct 2004 09:59:43 -0400
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 18.104.22.168/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:
- » SQL with special characters .. behaviour ?!
- » RE: SQL with special characters .. behaviour ?!