November 27, 2003 at 10:52 am
Hello Listers,
Hope your all fine.
I have a simple question: On a SQL Server 7.0 what determines the value for the Locale ID?
We have a client in the United States that have a server with the Locale Id set to 197636 which is the collation designator CHINESE_TAIWAN_BOPOMOFO (I think) and we don't understand why.
The only thing I can think of is the OS Windows Locale.
Thank's
Carl
November 27, 2003 at 11:13 am
Run
SELECT SERVERPROPERTY('collation')
to be sure.
November 27, 2003 at 12:07 pm
Don't Forget that we are on a SQL Server 7.0.
SERVERPROPERTY does not exists:
SELECT SERVERPROPERTY('collation')
Server: Msg 195, Level 15, State 10, Line 1
'SERVERPROPERTY' is not a recognized function name.
N.B. We used sp_helpsort to see the Locale Id
Best regards,
Carl
November 27, 2003 at 2:00 pm
Nobody is able to answer to that question:
On a SQL Server 7.0 what determines the value for the Locale ID?
There is almost nothing in BOL about that.
Carl
November 28, 2003 at 6:36 am
AFIK it is set during install and relates to the unicode settings. I can't remember if you can select it, MS reckons you can. The normal id is 1033, is it possible that someone set it differently during install. Sorry I can't be more specific.
Far away is close at hand in the images of elsewhere.
Anon.
November 28, 2003 at 10:54 am
Thank's David,
The server was not installed by me.
We frequently install SQL Server 7.0 on laptop and I don't remember the wizard offering me that choice...
Carl
December 2, 2003 at 10:44 pm
Carl,
Upon installation SQL gets its default collation from the Operating System. Locale settings on the OS can be changed in 'Regional Settings' which is found in Control Panel.
If you want to change the SQL collation from the default you must choose 'custom installation' during the SQL install otherwise you are not presented with the option to change it.
Hope this helps,
Angela
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply