Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Basic Between Clause and Special Char
Any One,
I am supporting a Peoplesoft 6.0 application with an Oracle Database 7.3.4. Peoplesoft is issuing the following select on a users machine: SELECT DISTINCT PRODUCT, BUSINESS_UNIT, PROP_NAME, PROP_SHORT_NAME, PROP_STATUS, TYPE1, RES_TYPE FROM PS_PA_PROPERTY WHERE PROP_SHORT_NAME BETWEEN 'WAC' AND 'WACū' ORDER BY PROP_SHORT_NAME, PRODUCT
Please notice the weird character in the between clause (hex FE, dec 254). This will execute on some users machines and not on others. I can then cut and paste this querry to a telnet session to a UNIX box in a SQLPlus session and it works! It appears to be login independent, that is the login has no affect on what is going on. It appears to be maching dependent, maybe registery.
This special char is being converted by Oracle in some manner. Does anyone have a clue what is going on?????????
Mike Guice
Insignia Holdings ESG
Received on Thu Aug 12 1999 - 09:49:54 CDT