Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASCII to CHR issues between different Oracles

user7385944Aug 8 2012 — edited Aug 9 2012
One database is using character set us7ascII and the other isA16UTF16.

Trying to get a field value from one table by looking for two other fields in the same table being = CHR(255).

Without the CHR(255) filter I get info back. When it is in the thing runs forever.

Is the different character sets the problem? How do I get around it?

Tried using where ASCII(field) = 255 but the same result; runs forever.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2012
Added on Aug 8 2012
6 comments
895 views