On 2019-12-16 15:42, Norbert Saint Georges wrote:
Mark Rotteveel a écrit :
I can't answer that without information what the problem is.
Mark
okay :-)
I was actually referring to what you meant with:
"""
t = kb
t1 = ok
"""
Especially regarding the 'kb', I had no clue what you meant, but I guess
it was an overflow error.
I am developing an application to import Oracle DBs to Firebird 4.
when for example, a table is declared like this:
CREATE TABLE part (
part_id NUMBER GENERATED BY DEFAULT AS IDENTITY,
part_name VARCHAR2 (255) NOT NULL,
buy_price NUMBER (9.2) CONSTRAINT check_pos_buy_price CHECK
(buy_price> 0),
PRIMARY KEY (part_id)
);
part_id is a number that has the
value:203974809258041991228294191469794647457
what should i use in firebird 4 to import part_id?
See my other post: that value is too big to fit in a NUMERIC(38) and
there is no other numeric type in Firebird that would allow you to keep
the number with all precision. So you would have to use a CHAR or
VARCHAR (or maybe a BINARY (CHAR CHARACTER SET OCTETS) and encode the
number in binary format if you're looking to save space).
BTW: Such an extremely high part-number seems rather odd, and could
indicate those numbers encode additional information, which may indicate
this should be a string anyway.
Mark
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
