Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Bulk Insert Problem

Author  Topic 

cge_1215
Starting Member

1 Post

Posted - 2005-12-14 : 22:50:03
Hi,

Got problem using Bulk Insert to Load a text file.
Data with Ñ was incorrectly uploaded to a temporary/transparent table.
I got a text file with data "DOÑA ELENA FLAT ANCHOVIES 56GM",
but it was uploaded as "DO-A ELENA FLAT ANCHOVIES 56GM".
Is there issue on loading character Ñ.

Please help.. many thanks!! =)

surendrakalekar
Posting Yak Master

120 Posts

Posted - 2005-12-15 : 02:06:41
quote:
Originally posted by cge_1215

Hi,

Got problem using Bulk Insert to Load a text file.
Data with Ñ was incorrectly uploaded to a temporary/transparent table.
I got a text file with data "DOÑA ELENA FLAT ANCHOVIES 56GM",
but it was uploaded as "DO-A ELENA FLAT ANCHOVIES 56GM".
Is there issue on loading character Ñ.

Please help.. many thanks!! =)



This may be problem of UNICODE. Read help regarding UNICODE, NVARCHAR, NCHAR

Surendra
Go to Top of Page
   

- Advertisement -