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.
| Author |
Topic |
|
ciaran
Starting Member
40 Posts |
 Posted - 2006-09-11 : 06:14:10
|
| Hi, I have a dts package which is importing alcohol products into a database. Some of the wine names have special characters attached to them. I need to preserve the data as is. The text file that the client hands off has the names with the special characters in them. When i import the data into a staging table it modifies the names into some thing else. I set the auto translate option to false on the connection objects in the package but this still doesn't work. The field where the product name is been placed is varchar(255). there is no truncation. Any ideas would be greatly appreciatedregardsCiaran |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-11 : 06:17:02
|
| What is "special character"? Are you talking about UNICODE strings?Try to change the VARCHAR(255) to NVARCHAR(255) and see if the "special characters" are preserved.Peter LarssonHelsingborg, Sweden |
 |
|
|
ciaran
Starting Member
40 Posts |
Posted - 2006-09-11 : 06:47:26
|
| French character sets in particular. Ya i changed the varchar to nvarchar as well. The only other solution that i can think of is to use bcp and a format file |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-09-11 : 08:47:51
|
| Do you not also need the "collation" to be right. |
|
|
|
ciaran
Starting Member
40 Posts |
Posted - 2006-09-11 : 09:06:14
|
| Hi Andrew, Yes the collation will cause a problem but if the data in the text file is in unicode then you can translate the data to which ever collation that you desire. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-09-11 : 10:01:48
|
quote:
Originally posted by ciaran
French character sets in particular. Ya i changed the varchar to nvarchar as well. The only other solution that i can think of is to use bcp and a format file
You maybe be able to use BCP with the -C RAW option.I ran into an similar problem with French language characters, and was able to resolve it that way.CODO ERGO SUM |
|
|
|
ciaran
Starting Member
40 Posts |
Posted - 2006-09-12 : 05:37:58
|
| Hi, I spent most of a day trying to figure this out. I eventually gave up and wrote a .net application that can be called from a dts package. This seems to work fine. |
|
|
|
|
|
|
Importing Special Characters