| Author |
Topic |
|
kote_alex
Posting Yak Master
112 Posts |
 Posted - 2009-01-14 : 08:17:47
|
| Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Romanian_CI_AS" in the equal to operation. [SQLSTATE 42000] (Error 468).My database in witch I store the data is set for collation "Romanian_CI_AS" .... but when I import data from a *.CSV file ... the Flat file conection is set for collation "Latin II"Any ideas.... ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-14 : 08:21:31
|
| how are you importing from csv? make sure you force collation to change using COLLATE clause while import |
 |
|
|
kote_alex
Posting Yak Master
112 Posts |
Posted - 2009-01-14 : 08:28:38
|
| how can I do a force collation? with data transformation ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-14 : 08:36:00
|
| how are you importing currently? using dts or openrowset? |
|
|
|
kote_alex
Posting Yak Master
112 Posts |
Posted - 2009-01-14 : 08:59:50
|
| via integration project in visual 2005 --- so dts |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-14 : 09:02:59
|
| then use derived column task |
|
|
|
kote_alex
Posting Yak Master
112 Posts |
Posted - 2009-01-14 : 09:06:50
|
| and what type of cast should I use for it to collate to "Romanian_CI_AS" ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-14 : 09:12:16
|
| just use columnname COLLATE newcollation |
|
|
|
kote_alex
Posting Yak Master
112 Posts |
Posted - 2009-01-14 : 09:14:49
|
| ==Description #2 collate Romanian_CI_AS .. this didn't work |
|
|
|
Tjompa
Starting Member
1 Post |
Posted - 2009-01-14 : 10:00:53
|
| Hi, im having almost the same problem.Im trying to do a BULK INSERT from a .CSV file. In the .CSV file i have Norwegian letters such as Å,Æ,Ø. CREATE TABLE bulkimport( ColumnName nvarchar(max) COLLATE Danish_Norwegian_CI_AS,)GOBULK INSERT bulkimport FROM 'C:\FILENAME.csv' WITH ( FIELDTERMINATOR = ';', ROWTERMINATOR = '\n' )So as you see i specifically set the Collation of the column in the new table to be danish_Norwegian collation. But still after the import the values change from Å,Æ,Ø to +, ÷ etc. Any suggestions of what to do? Is it so that the "Bulk insert" has its own collation aswell?Thankful for all help. -Tjompa |
|
|
|
kote_alex
Posting Yak Master
112 Posts |
Posted - 2009-01-15 : 02:24:21
|
| I'm using the import through a dts package... and like u I set the collation to "Romanian_CI_AS" and I still have problems... :( Help ! anyone ! |
|
|
|
|
Collation problem