SQL Window behaviour in 7.0.3.1115

[Eggie]

When I "Edit" a table in a SQL window and use the binocular to query data (e.g. the second field) then the resulting query does not have the entered data but :var2. (e.g. select t.*, t.rowid from lrm_communicatiemiddelen t
where cml_waarde = :var2) This seems to be the case only for varchar2 column.

 

[Marco Kalter]

For unicode data this is indeed the case, so that we can ensure that the unicode characters are sent to the server with the correct encoding.

 

[lav_spb]

Hi Marco, I'm using PL/SQL Developer Version 7.1.1.1339 and i have same problem, please comment this trouble...

 

[Marco Kalter]

To execute Query By Example SQL text with Unicode data to the server, you need to have a UTF-8 client character set. Otherwise the SQL Window will use bind variables, and explicitly pass the data as Unicode variables.