Re: Multilingual versions of SQL Express 2005 available ? Where ?
- From: stcheng@xxxxxxxxxxxxxxxxxxxx (Steven Cheng[MSFT])
- Date: Mon, 19 Dec 2005 02:19:19 GMT
Thanks for your further followup Keith,
So we haven't any further better means without the localized SQL express
version....
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: AcYCUWPp8cuRyUrdQMCAtx2umPEj0w==
| 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>
<16B33ACD-79EC-451D-A389-DBCD4483E487@xxxxxxxxxxxxx>
<MHeZgmhAGHA.2180@xxxxxxxxxxxxxxxxxxxxx>
| Subject: Re: Multilingual versions of SQL Express 2005 available ? Where ?
| Date: Fri, 16 Dec 2005 07:00:02 -0800
| Lines: 206
| Message-ID: <801E3C4C-ED18-433A-9390-B69CAEA8434F@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:74065
| X-Tomcat-NG: microsoft.public.sqlserver.setup
|
| 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
| > | > | >
| > | > | >
| > | > |
| > | > |
| > | > |
| > | >
| > | >
| > |
| >
| >
|
.
- References:
- Re: Multilingual versions of SQL Express 2005 available ? Where ?
- From: Mike Epprecht \(SQL MVP\)
- Re: Multilingual versions of SQL Express 2005 available ? Where ?
- From: Steven Cheng[MSFT]
- Re: Multilingual versions of SQL Express 2005 available ? Where ?
- From: Keith Dorken
- Re: Multilingual versions of SQL Express 2005 available ? Where ?
- From: Steven Cheng[MSFT]
- Re: Multilingual versions of SQL Express 2005 available ? Where ?
- From: Keith Dorken
- Re: Multilingual versions of SQL Express 2005 available ? Where ?
- Prev by Date: Re: Install of Management Studio fails with SMS
- Next by Date: Re: Newbie Q's
- Previous by thread: Re: Multilingual versions of SQL Express 2005 available ? Where ?
- Next by thread: Management Studio, RS databases missing
- Index(es):
Relevant Pages
|
