|
Home > Archive > BizTalk Server Setup > October 2004 > Supported collations in Biztalk Databases
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Supported collations in Biztalk Databases
|
|
|
| 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
| |
| Joe Eldridge \(MSFT\) 2004-10-20, 5:48 pm |
| 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
| |
|
| 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 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...
>
>
>
| |
| Joe Eldridge \(MSFT\) 2004-10-20, 5:48 pm |
| 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:
>
|
|
|
|
|