Hi all,I have an issue with a bulk insert that I did for loading a text file into a MS SQL table.The T-SQL script is summarizes to:DECLARE @OppFilePath varchar(64),@report nvarchar(32),@SQL_Ins varchar(2000) -- Path to the directory where the files should be loadedSET @OppFilePath = 'E:\Solution\XYZ\'SET @report = (SELECT repWWW FROM tbl_WWW)SET @SQL_Ins = 'BULK INSERT dbo.tbl_OpABC FROM ' + CHAR(39) + @OppFilePath + @report + CHAR(39) + ' WITH ( DATAFILETYPE = ' + CHAR(39) + 'widechar' + CHAR(39) + ', FIELDTERMINATOR = ' + CHAR(39) + '","' + CHAR(39) + ', ROWTERMINATOR = ' + CHAR(39) + '\n' + CHAR(39) + ', FIRSTROW = 2 )'-- Bulk insert the file into the Opportunity Details tableEXEC sp_sqlexec @SQL_Ins
The txt file can have, in the second column, names in english, chinese, japanese, etc. So I need my table to write the record as it should (latin characters for wertern languages, other character sets for eastern languages)The field that stores that information is nvarchar(max). I've tryes to save te text files as unicode, utf-8 and unicode big endian.I don't know what I'm missing or if I need to retrieve the stored data with a special parameter on the select query to view the chinese and japanese kanjis and the latin letters. I can only see the latin letters right (english, spanish, portuguese, etc).Any ideas?Thanks in advance
BULK INSERT with latin/chinese/japanese characters
Posted - 2010-03-17 : 19:35:25
Tara Kizer