View Full Version : NULL characters, Zeroes, and bcp

06-15-2004, 03:34 PM
Hi! It's been a long time since I've asked for help here, but I'm definitely in kind of a pinch.

Another developer here decided to rewrite some export scripts to use the bcp utility with SQL Server, and this seems to be working well, but it inserts NULL characters and zeroes all over the place. Anyone had experience with this at all?

Roy Sinclair
06-15-2004, 06:25 PM
Slap his hands and tell him to leave well enough alone. I've found that those utilities like BCP always tend to create sub-optimal results and that custom scripts do a better job since they can create exact results.

06-15-2004, 07:42 PM
Ahh, too late now... oh well I managed to get it working, just have to turn any empty strings into NULL explicitly...