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 hav
e
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 wher
e
> 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 h
ave
> 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 stil
l 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...
>
>|||> 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 quest
ion satisfy the
requirements? If all is OK, then fine. If, you for instance need some differ
ent sorting than what
the columns you sort over defines, then yes you would need to add COLLATE to
the 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...[vbcol=seagreen]
> 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:
>