Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    56

    Unanswered: ASCII (160) in BCP to txt file

    Hi,
    We have a problem on a bcp from our db to txt files. We sometimes get a character in the text file but in our database it shows up as char(160) which is a non breaking space nbsp . I know there is a switch that you can turn on bcp to use just unicode characters but that makes the txt files alot larger.
    Does anyone else have a workaround?

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I am going off memory here but I think we had this problem and use the RAW code page setting

Posting Permissions

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