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 msdn.microsoft.com. Paul Deuter Plumtree Software -----Original Message----- From: Magda Danish (Unicode) [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 12:17 PM To: [EMAIL PROTECTED] Subject: SQL server 7.0 & Unicode locale ID -----Original Message----- From: Howarth, Peter Sent: Mon 5/21/2001 6:22 AM To: [EMAIL PROTECTED] Cc: 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 appreciated. Regards, 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 [EMAIL PROTECTED] > >
