Hi!

  I have faced with a problem of support of floating-point numbers.
  If NLS_TERRITORY set to territory for which a decimal separator is the comma
  (for example, CIS) the following code works incorrectly:

  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

  Same bug with insert operation when i try to insert number to table.

-- 
Best regards, Nikolay Melekhin mailto:[EMAIL PROTECTED]

Reply via email to