ASCII to CHR issues between different Oracles
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.