db-derby-user mailing list archives

Hi there,

I am trying to make a selection from the systemtables and running into 
an error message. The select string is
    select * from SYS.systables t where t.tablename = 'mytable'

(The table 'mytable' really is existing in systables.tablename.)
The error message is
   Comparisons between 'VARCHAR' and 'CHAR' are not supported.

What am I doing wrong?

tom