Post reply

bcp error - Code page is not supported

  • February 25, 2006 at 12:45 am

    #171245

    Hi 

    I'm trying to run the following bcp command:

    bcp "dbName.dbo.tblName" in input.dat -c -q -SserverName -Usa -Pbullshit

    I get the following errors:

    1.Code Page 862 is not supported

    2.Unable to resolve column level collations

    How can I resolve these problems ?

    Thanks

    David

  • February 28, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • February 28, 2006 at 8:16 am

    #623702

    Is this SQL Server 2000 or 7?

  • March 2, 2006 at 1:39 pm

    #624459

    Hi,

    did you check the file? collations....maybe there some junk or invalid characters? I had some problems with bcp - files format, files data, separators, new lines, format files...Try to break file and process one small part. If it's OK (couple records), then somewhere in the middle of the file something wrong with the data(I think).

  • March 6, 2006 at 9:06 am

    #624941

    Codepage 862 seems to be Hebrew (DOS).

    Is this what the file contains?

    Perhaps you need to install support for Hebrew in order to load the file successfully..?

    /Kenneth

  • March 6, 2006 at 4:39 pm

    #625070

    You could try another codepage (1255?).

    You could look in the machine's registry to see what codepages it has registered support for:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage

  • March 6, 2006 at 4:40 pm

    #625071

    (Hit too soon.)

    You could manually convert your source files to another encoding, eg,

    type original_file | iconv -f CP862 -t UTF-8 > new_file

    (which converts the file to Unicode UTF-8 encoding)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply