bcp db-library problem: how to convert decimal to varchar correctly 
Author Message
 bcp db-library problem: how to convert decimal to varchar correctly

Hi,

when I using bcp db-library functions(bcp_columns, bcp_colfmt) to copy
a decimal column to a file field( from sqldecimal to sqlchar), the
conversion from sqldecimal to char seems to be totally wrong. I got a
junk string in the field instead of correct data. If coping decimal
column directly to the file field(from sqldecimal to dbdecimal), the
data is also incorrect.

Is it a known bug for sqlserver?

could anyone help me?

thanks in advance

jinlei



Sat, 16 Sep 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. HELP NEEDED FOR SQL SERVER DB-LIBRARY :- ERROR WHILE RETRIEVING/CONVERTED DECIMAL DATA

2. DTS does not convert varchar to decimal,

3. Converting from varchar to decimal

4. Convert varchar to numeric/decimal

5. converting a varchar to a decimal value

6. Convert Varchar to Decimal

7. convert float to varchar only returns 5 decimals places

8. BCP problem w/ DB-LIBRARY

9. bcp problem within C++ and DB-Library

10. Help:copy decimal data from SQL server to file using db-library functions

11. Decimal with DB library

12. convert foat to decimal. Not showing decimal values


 
Powered by phpBB® Forum Software