On Wed, Sep 26, 2012 at 03:10:07PM -0700, Maximiliano Robaina wrote:

> Hi (again),
>
> Testing django-firebird I caught this error:
>
> Error while executing SQL statement:\n- SQLCODE: -303\n- Incompatible column/host variable data type\n- Dynamic SQL Error\n- SQL error code = -303\n- conversion error from string "2012-10-10 16:34:30.072356"', -303, 335544569)
>
> (BTW, I can found what -303 is)
>
>
> The sql statement is:
>
> INSERT INTO "DJANGO_SESSION" ("SESSION_KEY", "SESSION_DATA", "EXPIRE_DATE")
> VALUES ('239a187593169b5b12cac16fbb19032c', 'ZTliNzMyZTU4MWZkODI0ODg4ZTM5MzQ3Yzk4YzdlYmQ4ODkzNWE0ODqAAn1xAS4=', '2012-10-10 16:34:30.072356')
>
> Then, I run this sql on FlameRobin and I get a different error code:
> SQL Message : -413
> Overflow occurred during data type conversion.
>
> Engine Code    : 335544334
> Engine Message :
> conversion error from string "2012-10-10 16:34:30.072356"
>
>
>
> So, two questions:
>
> 1. What is the real error code -413 or -303?
>
> 2. What is the best approach to resolve this? Replaces 6 digits microseconds to 4 digits allowed in Firebird?

You need to do the conversion from 6 to 4 like in
the kinterbase driver for django


6 digits microseconds are not implemented in Firebird yet

I will open a bug/feature request