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

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

  • cannot convert between unicode and non-unicode string data types
    ... Cindy, I have the same problem, there is a solution, In the OLE DB Destination component, in the Mappings option in the input column you must choose the Data Conversion., and that's it. ... I am converting a simple (at least in the SQL Server 2000 DTS days) to this ... error message stays the same ... numerous times I have inserted the transformation task between the oracle ...
    (microsoft.public.sqlserver.dts)
  • Re: xp_msver
    ... I would usually recommend you call Microsoft PSS with Access Violation ... >>> We're getting the following error message when the xp_msver is called ... >>> I checked the SQL permissions and the public role has exec privileges. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Timeout Error
    ... "Robert Lakinski" wrote: ... but you can access data in Sql server via MS ... I don't know why I got the error message. ...
    (microsoft.public.sqlserver.server)
  • Re: Multilingual versions of SQL Express 2005 available ? Where ?
    ... The error code alone is not sufficient. ... error code which is represented in the parameters used to format the SQL ... language is used. ... > we may consider provide localized error message according to the error ...
    (microsoft.public.sqlserver.setup)
  • Re: cannot convert between unicode and non-unicode data types
    ... product can't actually produce a meaningful error message. ... oracle and the sql database. ... Tried dumping to a raw file but the output is still unicode when I try to ...
    (microsoft.public.sqlserver.dts)
Loading