Multiple Collations in SQL Server 2000

Hi all.
Any assistance regarding this would be greatly appreciated.
I currently have my db's set up using the SQL_Latin1_general_CP1253_CI_AI
which is the Greek Character Code. We have a new business requirement where
we need to store Swedish characters as well. Both greek Characters and
Swedishc characters would need to be stored in the same table.
My question is this - could I use the 850 (multilingual) character code to
handle both the Greek and Swedish and also English Characters or would I have
to do something else?
Many thanks.I suggest you use Unicode datatypes for this. Note that the collation still determines some
nationalization aspects, namely sort order.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"xyberdobs" <xyberdobs@.discussions.microsoft.com> wrote in message
news:9DA9110A-2F37-4878-8702-CB865326FB3F@.microsoft.com...
> Hi all.
> Any assistance regarding this would be greatly appreciated.
> I currently have my db's set up using the SQL_Latin1_general_CP1253_CI_AI
> which is the Greek Character Code. We have a new business requirement where
> we need to store Swedish characters as well. Both greek Characters and
> Swedishc characters would need to be stored in the same table.
> My question is this - could I use the 850 (multilingual) character code to
> handle both the Greek and Swedish and also English Characters or would I have
> to do something else?
> Many thanks.|||Hi Tibor.
Many thanks for that.
Just another question - would the developers need to state the collation
when retrieving the values from the table, or would it be fine to do a std
SELECT statement?
Thanks
"Tibor Karaszi" wrote:
> I suggest you use Unicode datatypes for this. Note that the collation still determines some
> nationalization aspects, namely sort order.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "xyberdobs" <xyberdobs@.discussions.microsoft.com> wrote in message
> news:9DA9110A-2F37-4878-8702-CB865326FB3F@.microsoft.com...
> > Hi all.
> > Any assistance regarding this would be greatly appreciated.
> >
> > I currently have my db's set up using the SQL_Latin1_general_CP1253_CI_AI
> > which is the Greek Character Code. We have a new business requirement where
> > we need to store Swedish characters as well. Both greek Characters and
> > Swedishc characters would need to be stored in the same table.
> > My question is this - could I use the 850 (multilingual) character code to
> > handle both the Greek and Swedish and also English Characters or would I have
> > to do something else?
> >
> > Many thanks.
>
>|||> Just another question - would the developers need to state the collation
> when retrieving the values from the table, or would it be fine to do a std
> SELECT statement?
It depends... In what way would not the collation for the column(s) in question satisfy the
requirements? If all is OK, then fine. If, you for instance need some different sorting than what
the columns you sort over defines, then yes you would need to add COLLATE tothe ORDER BY clause.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"xyberdobs" <xyberdobs@.discussions.microsoft.com> wrote in message
news:92EC3872-AA0D-4B71-A5E9-FC8A123714E1@.microsoft.com...
> Hi Tibor.
> Many thanks for that.
> Just another question - would the developers need to state the collation
> when retrieving the values from the table, or would it be fine to do a std
> SELECT statement?
> Thanks
> "Tibor Karaszi" wrote:
>> I suggest you use Unicode datatypes for this. Note that the collation still determines some
>> nationalization aspects, namely sort order.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "xyberdobs" <xyberdobs@.discussions.microsoft.com> wrote in message
>> news:9DA9110A-2F37-4878-8702-CB865326FB3F@.microsoft.com...
>> > Hi all.
>> > Any assistance regarding this would be greatly appreciated.
>> >
>> > I currently have my db's set up using the SQL_Latin1_general_CP1253_CI_AI
>> > which is the Greek Character Code. We have a new business requirement where
>> > we need to store Swedish characters as well. Both greek Characters and
>> > Swedishc characters would need to be stored in the same table.
>> > My question is this - could I use the 850 (multilingual) character code to
>> > handle both the Greek and Swedish and also English Characters or would I have
>> > to do something else?
>> >
>> > Many thanks.
>>