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 |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2006-12-06 : 08:37:41
|
| Hi all,I'm setting up a brand new database for an application that's beeing used by a branch in Finland. The collation for Finland is Finnish_Swedish_CI_AS with codepage 1252 and data from this system is supposed to be fed in to our datawarehouse which is collation Danish_Norwegian_CI_AS but also with codepage 1252. Does the same codepage mean that they are directly compatible?--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-07 : 00:45:57
|
| No, they are not compatible.plz read this link from 7th point.http://www.sql-server-performance.com/vg_database_comparison_sp.aspits me monty |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-12-07 : 02:17:55
|
| Umh...so how does one solve issues like this? Having them both using the same collation is not possible, and using unicode datatypes is not really desirable.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-07 : 02:36:55
|
| When do you break compatability?The alphabets are not that far from oneother. The two countries' characters are all defined in codepage 1252.Peter LarssonHelsingborg, Sweden |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-12-07 : 03:00:09
|
| To be honest I don't know, I've never really had to deal with collation issues before. But if you read column #7 in monty's link it states quite clearly that you could suffer from collation problems even if the codepages are the same. We just want to be prepared for any problems that might arise...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
Collation compatibility