On Tue, 25 Feb 2003 01:17:39 +0100, you (K�re Olai Lindbach <[EMAIL PROTECTED]>) wrote:
>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); CREATE TABLE testtable (firstfield int); -- Of course ;-) >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
