I need to select by date in a SQL query, for example
SELECT * FROM foo WHERE date = '2009-09-09'
That query works in my Hypersonic test database, but not Oracle, which seems to requires:
SELECT * FROM foo WHERE date = TO_DATE('2009-09-09', 'yyyy-mm-dd')
Is there a way to select by date uniformly across these two databases?
...
Developers of hypersonic promise increase of performance?
But I'm afraid problems with administrating and other aspects of using hsqlDB.
Are anybody using this in production? Is it good idea?
...
The JBoss developers warn against the use of HSQLDB as a persistent storage (see JBoss wiki). I am confused though, because HSQLDB appears to be used heavily in production.
Especially, the above mentioned page seems to warn against the use of HSQLDB entirely and not against the use in conjunction with JBoss.
Is it still not recommendab...
Like in Oracle VARCHAR( 60 CHAR ) I would like to specify a varchar field with variable length depending on the inserted characters.
for example:
create table X (text varchar(3))
insert into X (text) VALUES ('äöü')
Should be possible (with UTF8 as the default charset of the database).
On DB2 I got this Error: DB2 SQL Error: SQLCODE...