Re: Multilingual versions of SQL Express 2005 available ? Where ?

The error code alone is not sufficient. You also need the context of the
error code which is represented in the parameters used to format the SQL
server's sys.message. Even having the parameters as provided to SQL server to
raise the error would save the step of having to reverse parse the error
message to determine the context of the error.

If this was added to SqlException as a collection of parameters, then any
program would
be able to determine the context of the error code regardless of what
language is used.

Regards, Keith

"Steven Cheng[MSFT]" wrote:

> Thanks for your response Keith,
>
> So seems your scenario is much more complex than I've expected :-) . I
> agree that such level globalize will be a bit hard....
> BTW, is it possible that you done it at programming code level. e.g if
> you're using .net ADO.NE, since the ADO.NET will return the SQL error code,
> we may consider provide localized error message according to the error
> code, those static error messages can be predefined and store in resource
> files....
>
> Regards,
>
> Steven Cheng
> Microsoft Online Support
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
>
>
>
> --------------------
> | Thread-Topic: Multilingual versions of SQL Express 2005 available ? Where
> ?
> | thread-index: AcYBdp/1mj67SjPpTeezNkg8eotf7w==
> | X-WBNR-Posting-Host: 192.102.11.2
> | From: =?Utf-8?B?S2VpdGggRG9ya2Vu?= <kadorken@xxxxxxxxxxxxx>
> | References: <D9001CF8-0AEE-47ED-B98E-9C2CAE9D2E79@xxxxxxxxxxxxx>
> <eFWrF#NAGHA.1032@xxxxxxxxxxxxxxxxxxxx>
> <rHTtQyTAGHA.1504@xxxxxxxxxxxxxxxxxxxxx>
> | Subject: Re: Multilingual versions of SQL Express 2005 available ? Where ?
> | Date: Thu, 15 Dec 2005 04:54:02 -0800
> | Lines: 123
> | Message-ID: <16B33ACD-79EC-451D-A389-DBCD4483E487@xxxxxxxxxxxxx>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.setup
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.setup:74048
> | X-Tomcat-NG: microsoft.public.sqlserver.setup
> |
> | Thanks for the information;
> |
> | I actually need to test the foreign languages as shipped in the
> sys.messages
> | view of the database for interpreting database errors properly in foreign
> | languages. I guess this part will have to be deferred until the foreign
> | languages ship.
> |
> | We need to 'interpret' the error message returned in a SqlException so
> that
> | a proper message that makes sense to an end user can be conveyed.
> |
> | The example I use is the SQL error message returned from the SQL server:
> | Violation of UNIQUE KEY constraint 'UQ__XYZ__234566''. Cannot insert
> | duplicate key in object 'dbo.TABLE'
> | (Error message number 2627)
> |
> | needs to be interpreted and the user informed:
> |
> | You cannot enter a duplicate 'code' for the 'xyz'.
> |
> |
> | The 'code' and 'xyz' part of the message has to be 'extracted' from the
> | constraint (UQ__XYZ...) stored in the database by
> | 1) parsing the error message (in whatever language...) and extracting the
> | parameters from the error message (preserving what parameter number each
> is
> | based on the foreign language)
> | 2) using the us_english version of the error message format (from
> | sys.messages), determine which parameter is the constraint name (in this
> case)
> | 3) using the constraint name, retrieve from the database INFORMATION
> schema
> | the table and columns involved in the constraint violation
> | 4) Map the information from 3 back through the DataBindings collection to
> | determine WHICH windows control on the user interface has the duplicate
> | information.
> | 5) POST the error message to the appropriate control feedback provider so
> | the user is informed which control(s) have incorrect values.
> |
> |
> | Sound like fun ? :)
> |
> | Would be easier if SqlExceptions had a better interface for at least
> | extracting the parameters supplied to the error message as numbered
> | parameters rather than us having to reverse format the actual error
> message
> | text (in foreign languages)
> |
> | This discussion was made with Microsoft Advisory services over a year ago
> | and the above is the only solution we came up with.
> |
> | "Steven Cheng[MSFT]" wrote:
> |
> | > Hi Keith,
> | >
> | > As Mike has said, so far t here is no other language version of the SQL
> | > EXPRESS 2005 available. However, as for testing our own applicaiton's
> | > internationalization ability, it is not necessary to have a specific
> | > language version of SQL Express. All the english version SQL Server can
> | > store all the characters of other language.... Generally, if our
> | > application is using Unicode as the text's charset, the SQLserver's
> buildin
> | > unicode text column can correctly store them... Also, if you want to
> store
> | > the text as a specific charset(code page...), the SQLserver also
> provide
> | > most common Collations that mapped to those common charsets or
> codepages....
> | >
> | > There is a msdn article dicussing on the SQL 2000's international
> support,
> | > it also applies to all the sqlserver instances....
> | >
> | > #International Features in Microsoft SQL Server 2000
> | > Thanks,
> | >
> | > Steven Cheng
> | > Microsoft Online Support
> | >
> | > Get Secure! www.microsoft.com/security
> | > (This posting is provided "AS IS", with no warranties, and confers no
> | > rights.)
> | > --------------------
> | > | From: "Mike Epprecht \(SQL MVP\)" <mike@xxxxxxxxxxxx>
> | > | References: <D9001CF8-0AEE-47ED-B98E-9C2CAE9D2E79@xxxxxxxxxxxxx>
> | > | Subject: Re: Multilingual versions of SQL Express 2005 available ?
> Where ?
> | > | Date: Wed, 14 Dec 2005 19:52:25 +0100
> | > | Lines: 29
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> | > | X-RFC2646: Format=Flowed; Original
> | > | Message-ID: <eFWrF#NAGHA.1032@xxxxxxxxxxxxxxxxxxxx>
> | > | Newsgroups: microsoft.public.sqlserver.setup
> | > | NNTP-Posting-Host: 196.1.62.81.cust.bluewin.ch 81.62.1.196
> | > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
> | > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.setup:74037
> | > | X-Tomcat-NG: microsoft.public.sqlserver.setup
> | > |
> | > | Hi
> | > |
> | > | Non-English versions will be shipping early 2006.
> | > |
> | > | Regards
> | > | --------------------------------
> | > | Mike Epprecht, Microsoft SQL Server MVP
> | > | Zurich, Switzerland
> | > |
> | > | IM: mike@xxxxxxxxxxxx
> | > |
> | > | MVP Program: http://www.microsoft.com/mvp
> | > |
> | > | Blog: http://www.msmvps.com/epprecht/
> | > |
> | > | "Keith Dorken" <kadorken@xxxxxxxxxxxxx> wrote in message
> | > | news:D9001CF8-0AEE-47ED-B98E-9C2CAE9D2E79@xxxxxxxxxxxxxxxx
> | > | >I need to test multilingual support for our application in French
> | > (Canada)
> | > | > version of SQL Express 2005, but cannot find where (if) it is
> available?
> | > | >
> | > | > Thanks in advance for any pointers as to where the multlingual
> versions
> | > | > are
> | > | > hiding.
> | > | >
> | > | > Keith
> | > | >
> | > | >
> | > |
> | > |
> | > |
> | >
> | >
> |
>
>
.

Relevant Pages

  • Re: 0x800a0cb3 when Update record
    ... providers may have different error messages for the same error code. ... hadn't entered the error message and just sent it. ... The sql variable contains the sql statements that are in the Format. ...
    (microsoft.public.data.ado)
  • Unexpected Error - Error Code: -2147221231
    ... I'm receiving a message: An unexpected error occurred - error message: Automation Error ... Class Factory cannot supply requested class ... Stack:=Execute SQL; error code: -2147221231 ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Full-Text Catalog does not build...
    ... You're welcome, Oleg, ... I've not confirmed if the Arabic language will be a FTS supported ... language in SQL Server 2005, you may want to review the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL
    ... Language can and do this. ... SQL is typed, ... How about something from the domain of custom biz apps. ... yet nobody would even try to use RDBMS for that. ...
    (comp.object)
  • Re: Setup Fails
    ... Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup ... Bootstrap\LOG\SqlSetup0017.cab" Error Code: 2 ... Bootstrap\LOG\Files\SQLSetup0017_SNOWFLAKE_.NET Framework 2.0 LangPack.log" ... which version and edition of SQL Server is this? ...
    (microsoft.public.sqlserver.setup)