Re: International Settings for SQL 2000

quinto (fiorelli.m@xxxxxxxxx) writes:
Can someone shed some light on the advantages of using Enterprise vs
Standard strictly from a language support perspective?

I can't think of any.

Also, is there any caveats or other considerations that I should keep
in mind to make sure that the developers have all they need to develop
these multi language sites?

First of all, you need to decide on how to store the multi-lingual
data. In clear text this means you need to settle on how to store
the Japanese data. I would settle for Unicode and use nvarchar columns,
but I believe Shift-JIS is still in widely use, and this if you charset
varchar is your choice.

To get a multi-lingual application right, you need to make a basic
design right from the start, because later on, it can be very difficult
to change. And very expensive.

In our application, about all tables that define entities have a
"name table" which holds the names of the entities in various languages.
So for, say, instrumenttypes with ityid as the primary key, there is
also a table instrumenttypenames with ityid and languageid as PK. I
should that this far we support only the Nordic languages togther with
German and English.

But that is only part of the problem. One thing we have entirely
negclected is the collation, which controls sorting and comparison.
If users are to perform searches, you may have to have different
collations for the various languages. This is another issue you need
to research early.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Portuguese language support for full-text?
    ... While SQL Server supports the Portuguese language, ... unfortunately Portuguese is not one of these languages. ... Note, with the Neutral word breaker, you lose the ...
    (microsoft.public.sqlserver.fulltext)
  • Im a New bie to SQL SERVER 2005
    ... I'm using SQL Server 2005 on a .NET project that deals with multiple ... languages, During installation i made the SQL collation to default. ...
    (comp.databases.ms-sqlserver)
  • search brings no results
    ... how the full-text feature works using Word documents in different languages ... (English, Persian, Arabic). ... I modified the SQL Server Resource Kit sample called "Bulk Image Insert ... I also populated the catalog. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Im a New bie to SQL SERVER 2005
    ... I'm using SQL Server 2005 on a .NET project that deals with multiple ... languages, During installation i made the SQL collation to default. ...
    (comp.databases.ms-sqlserver)
  • Re: Case Statement
    ... Yes, True can be 1 for things like SQL Server and in some other languages, but by the time you've assigned them to boolean values in VB/VBA, they're necessarily going to have been converted to -1. ...
    (microsoft.public.access.modulesdaovba)