Problem with data storage
От | Francois Cote |
---|---|
Тема | Problem with data storage |
Дата | |
Msg-id | op.t83qblr27xd6k3@fsider2.gateway.2wire.net обсуждение исходный текст |
Список | pgsql-novice |
Hi, I'm still doing test with PostgreSQL with C++ Builder using MicroOLAP DAC and one big problem I have is with numerical data type. Suppose the following table: CREATE TABLE "TestNumbers" ( "TestInteger" integer, "TestReal" real, "TestMoney" money, "TestDouble" double precision, "TestNumeric" numeric(20,2) ); Now, after adding a record with the value 22443018 for each fields I finally have the following values: TestInteger: 22443018 TestReal: 22443000 TestMoney: {get a read error at 0x00000000, probably microOLAP DAC related} TestDouble: {empty/no value displayed} TestNumeric {empty/no value displayed} Using pgAdmin III, I see the same values. Now Inserting data in the table using pgAdmin III: INSERT INTO "TestNumbers"( "TestInteger", "TestReal", "TestMoney", "TestDouble", "TestNumeric") VALUES ('22443018', '22443018', '22443018', '22443018', '22443018'); The results are in pgAdmin are: TestInteger: 22443018 TestReal: 2.2443e+007 TestMoney: -$20,506,654.96 TestDouble: 22443018 TestNumeric: 22443018.00 And looking at this record from C++ Builder, I have the following values: TestInteger: 22443018 TestReal: 22443000 TestMoney: -$20,506,654.96 TestDouble: {empty/no value displayed} TestNumeric: {empty/no value displayed} I have made the same test with a simple Paradox table, and all values are displayed correctly. Does anybody knows why the rounding occurs, why the negative value and why the blank value? Thanks a lot Francois
В списке pgsql-novice по дате отправления: