February 25, 2006 at 12:45 am
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
Is this SQL Server 2000 or 7?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
March 2, 2006 at 1:39 pm
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
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
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
(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