collation on nchar column

Hey eb
Whats the point in having a collation attached to a unicode
charecter typed column'
If you want to set a specific collation to character data, why
make it unicode on the first place'
Am I missing something here'
Thanks
ReaCollation isn't only the character set. It is also sorting order, case sensitivity, accent
sensitivity etc.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rea" <Rea@.discussions.microsoft.com> wrote in message
news:CA4DF029-A399-4FE0-B198-C7FC621F0691@.microsoft.com...
> Hey eb
> Whats the point in having a collation attached to a unicode
> charecter typed column'
> If you want to set a specific collation to character data, why
> make it unicode on the first place'
> Am I missing something here'
> Thanks
> Rea
>
>sqlsql

collation on nchar column

Hey eb
Whats the point in having a collation attached to a unicode
charecter typed column'
If you want to set a specific collation to character data, why
make it unicode on the first place'
Am I missing something here'
Thanks
ReaCollation isn't only the character set. It is also sorting order, case sensi
tivity, accent
sensitivity etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rea" <Rea@.discussions.microsoft.com> wrote in message
news:CA4DF029-A399-4FE0-B198-C7FC621F0691@.microsoft.com...
> Hey eb
> Whats the point in having a collation attached to a unicode
> charecter typed column'
> If you want to set a specific collation to character data, why
> make it unicode on the first place'
> Am I missing something here'
> Thanks
> Rea
>
>

Collation Danish_Norwegian_CI_AI

Hi,
We have some problems with the fact that SQL Server reads "aa" and "?" as
the character. I use the Danish_Norwegian_CI_AI collation on the table.
First i'd like to find a good chart of the different collations?
Secondly I'd like to know if someone knows a good way a round this?
Thanks in advance
Richard> First i'd like to find a good chart of the different collations?
select *
from ::fn_helpcollations

> Secondly I'd like to know if someone knows a good way a round this?
Try using the Danish_Norwegian_CI_AS (accent-sensitive) collation.
ML
http://milambda.blogspot.com/|||Ok, great
But aa is still read as ? ... It's probably correct according to the
Danish_Norwegian collation schema. But is there a place i can see whats in
these schemas? What the different collation actually means.
Richard
"ML" wrote:

> select *
> from ::fn_helpcollations
>
> Try using the Danish_Norwegian_CI_AS (accent-sensitive) collation.
>
> ML
> --
> http://milambda.blogspot.com/|||Try to make the column a unicode column
And try this link for the charts
http://developer.mimer.com/charts/
Hope this helps|||Hey, that's a very nice resource. Thanks.
ML
http://milambda.blogspot.com/