Query by example gives different result

[Paul Ljungqvist]

A collegue has a problem that I have not been able to track down.
She press Edit data on a table, then Query by example and enters, say C% as a search value, and press F8.
The expected query (which I allways get) is something like this:

select t.*, t.rowid from ksd_printerbin t
where paperbin_desc like 'C%'

.
But the query looks like this instead:

select t.*, t.rowid from ksd_printerbin t
where paperbin_desc like :var4

I have not been able to reproduce the issue on my computer, but I am sure it is a setting somewhere.
Please advice.

EDIT: We are using 7.1.5

 

[Marco Kalter]

This indicates that this is a UTF8 database. Could this be correct? On a non-UTF8 client the (possible) UTF8 characters need to be passed in a bind variable.

To circumvent this you can disable the "Unicode enabled" option (Tools > Preferences > Oracle / Options). In that case you cannot use any Unicode anymore of course.

 

[Paul Ljungqvist]

That solved it.
The reason why I could not reproduce it, was that I tried against another DB.

Thanks