db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vatter <thomas_vat...@web.de>
Subject systemtables
Date Tue, 04 Dec 2007 12:45:43 GMT
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?


View raw message