String variables in Direct Oracle Access are treated as VARCHAR2 variables on the Oracle Server. If you compare a CHAR column with a VARCHAR2 variable, trailing spaces are significant.

Use a Char variable in the TOracleQuery or TOracleDataSet for this where clause to fix the problem. You should also try to avoid CHAR columns in your database if you can.