Conversion or encoding error after importing text

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 2008 Forums

SSIS and Import/Export (2008)

Conversion or encoding error after importing text

Author

Topic

MCPieters
Starting Member

3 Posts

Posted - 2010-04-12 : 20:22:35

Hi All,

When I import the following tab separated text file an encoding error takes place:
{
'Cuba', Luis Ambos mundos (2007) (V)

'El de Chipiona', Antonio La guitarra muda (1953) [Himself]

'El Francés', José Alma gitana (1996) <45>
De todo corazón (2000) (TV) [Himself]
O que dis que din (2003) [Himself]
Premios Amigo 2000 (2000) (TV) [Himself]
Rosa y amigos (2002) (TV) [Himself]
}
The problem is with these kind of characters: 'é'. they transform into something like this: 'El FrancÚs', JosÚ.
The code i use is:
BULK
INSERT ActorTitlesTable
FROM 'C:\Movie-database\textfiles\Actor_Titles_Test.txt'
WITH
(
MAXERRORS = 0,
DATAFILETYPE='widechar',
FIELDTERMINATOR = '\t',
KEEPNULLS,
ROWTERMINATOR = '\n'
)
I also used DATAFILETYPE='char' , but this doesn't help. leaving the DATAFILETYPE out doesn't help either.
The Datatypes of the colums are nvarchar(max).

Does anyone of you know what does the trick?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources