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/