Double byte database - like '%' bug

Our team has encountered a problem using 7.1.4 Kanji Instance (a double byte instance)

I will explain the problem using an example:

Table: emp (emp_name varchar2(20), age NUMBER) Primary Key: emp_name.

SELECT COUNT(*) INTO :local_variable1
FROM EMP
WHERE EMP_NAME LIKE :local_varible2;

If the LOCAL_VARIBLE2 IS = '%' , THE QUERY RETURNS 0, instead of returning the number of rows in the table.

Please Note:

1. This problem exists on our 7.1.4 Kanji instance
2. The column in where clause is a Primary Key
3. local_variable2 is dynamic.
4. Have tested this using Pro*C & PowerBuilder.

Does anyone know any work arounds / fixes to this problem ??

Thanks Received on Wed Apr 26 1995 - 00:00:00 CEST