RE: SQL server 7.0 & Unicode locale ID

From: Paul Deuter (
Date: Mon May 21 2001 - 17:06:27 EDT

The LCID 1033 is the default locale for English (i.e. en-us).
The LCID 2057 is en-gb.

There is a list in Nadine Kano's book on Internationalization.
This info is almost certainly somewhere on

Paul Deuter
Plumtree Software

-----Original Message-----
From: Magda Danish (Unicode) []
Sent: Monday, May 21, 2001 12:17 PM
Subject: SQL server 7.0 & Unicode locale ID


        -----Original Message-----
        From: Howarth, Peter
        Sent: Mon 5/21/2001 6:22 AM
        Subject: Looking for some specific information:

        Dear Sir / Madam,
        I am having problems restoring a database using SQL Server 7.0,
the error
        being that the database was backed up using unicode locale ID
1033, and my
        server is using locale ID 2057. I can only set which region I
want on
        installation of SQL, and I'm trying to find a list of Regions vs
their ID
        numbers, so I can pick the correct region without having to try
each one
        through a lengthy install.
        Any help or pointers in the right direction would be much
        Peter Howarth
> Peter Howarth
> Web Developer
> Data Systems & Solutions
> PO Box 46
> Fishponds
> Bristol BS16 1YZ
> Phone: +44 (0)117 317 3837
> Fax: +44 (0)117 959 9028
> Email

This archive was generated by hypermail 2.1.2 : Fri Jul 06 2001 - 00:18:17 EDT