Hello Jeff,

> Can someone point me to any documentation on supported datatypes?
>
> I was creating table using "double" and it failed. Decimal, float,
> real all work fine.
>
> I came across the MS SQL to Firebird conversion page and it did
> indicate datatype 'double' was supported.
>
> SQL>create table Staff1 (id integer, salary double);
>
> Statement failed, SQLCODE = -104
>
> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown - line 1, char 136
> -,
>
> To my understanding of other database, there precision different
> between float and double, that is why I am interested in double.
>
> I guess I could use 'decimal (18, 4).
>

Use "double precision".

Alternatively, our database developer IDE would have done this
transformation withouts scripts, automagically, via the Schema
Migrator tool.

Check it out, Database Workbench at www.upscene.com

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com