Sybase bcp is changing real number format, how do I prevent this?
Posted on 2008-10-24
I'm running Sybase 11.9.2 and I am running the following bcp command:
bcp site1.ff.pricing out pricefile_tmp.out -c -t "\t" -r "\r\n" -Uff -Pxxxx
The pricing table being dumped has multiple columns formatted as "real". In the output file created by bcp, those values no longer match what is in the database, as shown below.
Value in Table Value in bcp output
Why is this occurring, and how do I stop it. I need to get the values to come out just as they are in the table.