Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Senior Coder
    Join Date
    Jun 2002
    Location
    41° 8' 52" N -95° 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts

    NULL characters, Zeroes, and bcp

    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?
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    Wichita
    Posts
    3,880
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    Check out the Forum Search. It's the short path to getting great results from this forum.

  • #3
    Senior Coder
    Join Date
    Jun 2002
    Location
    41° 8' 52" N -95° 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ahh, too late now... oh well I managed to get it working, just have to turn any empty strings into NULL explicitly...
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •