вівторок, 15 вересня 2009 р.

BCP and problems with Unicode

If you try loading the unicode file into mssql table that's what happens:

> bcp madhu1.dbo.testunicode in "D:\testunicode.txt" -S ABCSqlSrv -U sa -P sa -f "d:\fmt.txt"


Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file

0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1

=================================

contents of testunicode.txt are :


मधुकर|pune|33
राहुल|pune|36

==========================

contents of format file fmt.txt are

8.0
3
1 SQLNCHAR 0 0 "|" 1 name SQL_Latin1_General_CP1_CI_AS
2 SQLNCHAR 0 0 "|" 2 address SQL_Latin1_General_CP1_CI_AS
3 SQLNCHAR 0 0 "\r\n" 3 age SQL_Latin1_General_CP1_CI_AS


================

However, this can be avoided by using -w option and removing -f option

1 коментар:

  1. I agree with you that we get this message while you load unicode file in MS SQL table. I tried a lot but didn't reach to any solution. I tried what you described for this problem. The solution executes exactly the same way as explained. Thanks for giving me solution to my problem.
    sap ecc 7.0

    ВідповістиВидалити