Because DBD::Oracle fetches all data as strings.
You can "ALTER SESSION ..." to make your session use a different format.
Tim.
On Fri, Jan 17, 2003 at 12:57:21PM +0300, Nikolay Melekhin wrote:
>
> Hi!
> I already sent message about ORA-01722 error.
> But anybody has not answered. Why?
>
> If NLS_TERRITORY set to territory for which a decimal separator is the comma
> (for example, CIS) and create following table and one data record
> in it:
>
> CREATE TABLE TEST (A NUMBER(6,2));
> INSERT INTO TEST VALUES (2.5);
>
> $dbh->connect(...);
> $sth->prepare('SELECT * FROM TEST');
> $sth->execute;
> @row=$sth->fetchrow_array;
> print $row[0];
>
> The result will be string '2,5', but not number 2.5
>
> --
> Best regards, Nikolay Melekhin mailto:[EMAIL PROTECTED]
>
