Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    2

    Unanswered: BCP & odd charachters

    Hi

    When I BCP out some data from a database that contains german charachters ( in particular characters with hyphens & unlatts on them ), the letter appears as a square box when I open it in a text file.

    I run BCP locally on the server that the database is on.

    Any ideas what might be causing this? I have the local Regional settings of the server set to German but still no joy.

    Any ideas?

    Help!!

    J

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    What happens when you BCP the data back into a database? Sometimes certain products that we use to view files can not display none printable characters to they write out the 'box'. It does not mean that data is incorrect. You should create another test table and BCP the data into the new test table.
    MCDBA

Posting Permissions

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