What happens if you postpend a null character?
my $zero = "0\0";
Nope:
SQL> create table foo ( bar number(1,0) );
SQL> insert into foo (bar) values ( 1 );
1 row created.
SQL> insert into foo(bar) values ('2\0');
insert into foo(bar) values ('2\0')
*
ERROR at line 1:
ORA-01722: invalid number
Without some knowlege of underlying data types I cannot quote
stringy-numerics so that the database will accept them via
cut+paste from an error message from the vendor's SQL command
line utilities (e.g., sqlplus, shown above).
--
Steven Lembark 85-09 90th Street
Workhorse Computing Woodhaven, NY 11421
[EMAIL PROTECTED] 1 888 359 3508