Hi, I use ActiveState Perl v.5.6.1 build 635 on an MS win98 machine (my customer wants to run Perl on an MS NT-server)
I have installed ppm-wise: * DBI [ 1.32] * DBD-ODBC [1.03] The strange thing is that when I run my request towards an PostgreSQL DBMS (running on an RH Linux) via ODBC, all my "INT"-fields are returned as int when I use SELECT in an DBI selectxxx/fetchxxx-command. :-) But using the same SQL-syntax in creating a table, and using a select on this table via ODBC towards a MSSQL7 DBMS (running on an MS winNT-server), I get a decimal number back, like "2,00" instead of "2" (of course without the "-s (quotesigns)) :-( My test table might be as easy as: CREATE testtable (firstfield int); Has anyone seen this before, and might give me a hint to what to do, and where to look for the problem? :-) Anything to do with setup? Might I find out something useful using trace on this (what shall I look for)? How might I turn off decimal-type, and set it like int (if that would help)? I only use: INT, TIMESTAMP(PG)/SMALLDATETIME(MS), VARCHAR(n), CHAR(n), BOOLEAN(PG)/BIT(MS), TEXT where: (PG)=postgres-spesific (MS)= MSSQL-spesific -- mvh/Regards K�re Olai Lindbach
