Hi,
Can i use finnish_swedish collation (existing server) in Biztalk databases?
If not, how can i change collations in existing databases to supported ones?

Any help?

Regards,

Petri

[ Post a follow-up to this message ]

Hi, It supports non-binary case insensitive collations for the same
languages of OS that we support using the default collation.

An example:

If you have German Windows and you install SQL on that machine it will take
the default collation for German whatever it may be. That is a supported
scenario.

Something that is not supported is German windows and then installing SQL
server and choosing a swedish collation


--
Joe Eldridge [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
"Petri" <Petri@discussions.microsoft.com> wrote in message
news:8441C8A9-F3DD-4074-B614-62BAA47CD306@microsoft.com...
> Hi,
> Can i use finnish_swedish collation (existing server) in Biztalk
> databases?
> If not, how can i change collations in existing databases to supported
> ones?
>
> Any help?
>
> Regards,
>
> Petri

[ Post a follow-up to this message ]

Hi,
Thank you for the reply...
How about English windows and finnish collations;)?
Why the installation do not set collations (per database) by itself in case 
of
unsupported default SQL collation?

How can i change collations of biztalk databases to the supported ones (easy
way)?

Regards,

Petri

"Joe Eldridge (MSFT)" wrote:

> Hi, It supports non-binary case insensitive collations for the same
> languages of OS that we support using the default collation.
>
> An example:
>
> If you have German Windows and you install SQL on that machine it will tak
e
> the default collation for German whatever it may be. That is a supported
> scenario.
>
> Something that is not supported is German windows and then installing SQL
> server and choosing a swedish collation
>
>
> --
> Joe Eldridge [MSFT]
> This posting is provided "AS IS", with no warranties, and confers no right
s.
> "Petri" <Petri@discussions.microsoft.com> wrote in message
> news:8441C8A9-F3DD-4074-B614-62BAA47CD306@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

In Line

> Thank you for the reply...
You are welcome
> How about English windows and finnish collations;)?
No, Finish is not one of the languages we ship Biztalk in,
> Why the installation do not set collations (per database) by itself in
> case of
> unsupported default SQL collation?
We could do this but we onnly support it if the master is the same collation
as the rest
>
> How can i change collations of biztalk databases to the supported ones
> (easy
> way)?
You essentially have to rebuild the master database changing the collation
of it

>


--
Joe Eldridge [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
"Petri" <Petri@discussions.microsoft.com> wrote in message
news:546A32F8-F7A3-4B75-9D74-6F5F03C1C94B@microsoft.com...[vbcol=seagreen]
> Hi,
> Thank you for the reply...
> How about English windows and finnish collations;)?
> Why the installation do not set collations (per database) by itself in
> case of
> unsupported default SQL collation?
>
> How can i change collations of biztalk databases to the supported ones
> (easy
> way)?
>
> Regards,
>
> Petri
>
> "Joe Eldridge (MSFT)" wrote:
> 

[ Post a follow-up to this message ]