Problems with data type (number converted to char)

From: Manu <manu_at_phlcommunication.com>
Date: 28 May 2002 14:12:32 GMT
Message-ID: <ad038g$bb0$1@wanadoo.fr>

Hello,
I'm actually having problems with Oracle 8.1.7 and ASP2 (i don't know if this would happen on other versions, but these are mine). When doing vie ASP a "select * from TABLE where COLUMN='this' and OTHER='that';", the content of the columns that are NUMBER(5) is interpreted by ASP as being a character. I cannot add this number to another one in ASP without doing a cint() to force it to be considered as an integer, or doing a trim(). That's why I think that my 'select' brings me the number and blanks, making ASP consider it as a character. Is there a parameter that would tell Oracle to systematically trim all data? Or at least all data from NUMBER() types? So that the result of my query would not be ' 5 ' nor '5 ' but '5'... Or do you think the problem's elsewhere?

Thanks in advance.

E.Andreu Received on Tue May 28 2002 - 09:12:32 CDT