Hi,
I need a database that uses both nvarchar (unicode) and simple varchar-
fields. Before we have used some "Finnish/Swedish case-insensitive"
collation. What does the introduction of nvarchar-fields into our
database mean to the choice of the collation, should fex. the
WidthSensitive parameter of the collation be considered. Fex. thanks
to the "Finnish/Swedish case-insensitive" collation the scandinavian
åäö characters have been sorted right in char/varchar fields. Does the
collation affect the sorting of the nvarchar-fields and if so what's a
proper collation to use fex. when you primarily need Finnish/Swedish
sorting logic?
I remember that I have investigated these collation files in earlier
versions of the Sql Server, fex *.850 files etc. I have been able to
find out which collations fex. handles characters "w" and "v" as
different characters etc.
Is it possible to investigate these "collation-files" "for Sql Server
2005"?
I don't find any files, but I have found the syscharsets-table and the
definition field, but how to interpret this?
Regards RogerW.
I need a database that uses both nvarchar (unicode) and simple varchar-
fields. Before we have used some "Finnish/Swedish case-insensitive"
collation. What does the introduction of nvarchar-fields into our
database mean to the choice of the collation, should fex. the
WidthSensitive parameter of the collation be considered. Fex. thanks
to the "Finnish/Swedish case-insensitive" collation the scandinavian
åäö characters have been sorted right in char/varchar fields. Does the
collation affect the sorting of the nvarchar-fields and if so what's a
proper collation to use fex. when you primarily need Finnish/Swedish
sorting logic?
I remember that I have investigated these collation files in earlier
versions of the Sql Server, fex *.850 files etc. I have been able to
find out which collations fex. handles characters "w" and "v" as
different characters etc.
Is it possible to investigate these "collation-files" "for Sql Server
2005"?
I don't find any files, but I have found the syscharsets-table and the
definition field, but how to interpret this?
Regards RogerW.