I just saw this question on Stackoverflow http://stackoverflow.com/questions/18026907/firebird-insert-hex-values-into-tables-arithmetic-exception
And I wondered if it isn't a bug that hex values with 1-4 digits are integer and not smallint. Or at least: shouldn't the engine have enough context information to correctly convert 0x8000 to a smallint -32768 instead of an integer 32768? Mark -- Mark Rotteveel ------------------------------------------------------------------------------ Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel