473,224 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

Support for Spanish and English language

Hi,
I have a database and want to store data in Spanish and English. To
accompish this:

1. Do i need to create separate tables for both the languages like
items_en and items_sp?

2. If I opt for the UTF16 charset what single collation setting can I
use?

Thanks and Regards
Jackal Hunt

Feb 20 '07 #1
1 3200
(ja************@yahoo.com) writes:
I have a database and want to store data in Spanish and English. To
accompish this:

1. Do i need to create separate tables for both the languages like
items_en and items_sp?
It's impossible to answer without more knowledge about your requirements
and what sort of data we are talking about. But seprate tables does not
sound like a good idea.

One upon a time, our tables looked like this:

CREATE TABLE entities (entityid int NOT NULL,
entityname varchar(30) NOT NULL,
entitynamefor varchar(30) NOT NULL,
...

Where "name" was the Swedish name, and "namefor" the English name. But
when we entered the Finnish market, that was not acceptable, so we
switched to:

CREATE TABLE entities (entityid int NOT NULL,
entityname varchar(30) NOT NULL,
...

CREATE TABLE entitynames(entityid int NOT NULL,
languageid smallint NOT NULL,
entityname varchar(30) NOT NULL,
PRIMARY KEY (entityid, languageid))

That is, for every entity we have a look-up table for, there is also
a name table, that holds the name for the various languages. The
main table also has the name in the home language of the system, since
we cannot ensure that the users enters name in all languages that the
system support.

But I have to idea whether this is applicable to your system.
2. If I opt for the UTF16 charset what single collation setting can I
use?
If all you need to support is English and Spanish, you can go with
varchar if you like.

If you need sorting of your data, our scheme with a subtable of the
names is not workable. You can set the collation per column, so you
can have one Spanish column with Modern_Spanish_CI_AS and one
English column with Latin1_General_CI_AS.

In practice, though, it should work just fine to have Modern_Spanish
everywhere, since the effect on English will be miniscule. It's different
if you want to use Traditional_Spanish, where CH and LL sorts as
separate letters; that is not suitable for English.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Feb 20 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: ..... | last post by:
I have an established program that I am changing to allow users to select one of eight languages and have all the label captions change accordingly. I have no problems with English, French, Dutch,...
4
by: Jim Adams | last post by:
Anyone have any insights into this? I'm planning an upgrade to an existing ASP.Net project to support multiple display languages (e.g. English, Spanish, ...). I'd like to use a solution that...
3
by: clintonG | last post by:
I'm messing around with the Request.UserLanguages and the Request.ServerVariables("HTTP_ACCEPT_LANGUAGE"); to see how similar or dissimilar they may be. I observe and conclude that both get...
3
by: Chip | last post by:
There is surprisingly little information on the various encoding options for reading a text file. I have what seems to be a very basic issue: I'm reading a text file that includes Spanish...
4
by: =?Utf-8?B?Q2hyaXMgRGF2b2xp?= | last post by:
I have a need to translate a web page from english to spanish. Is there anything in .NET framework that does this? -- Chris Davoli
0
by: pziggs | last post by:
I have been working on a page in English, and today began tackling the Spanish version of the site. I'm curious because on the homepage (www.nuestracasa.com/esp/) it displays the spanish language...
1
by: DR | last post by:
how to determine what language a c# string is written in? is there any C# method to take a string and return what language it is in? e.g. english, hindi, spanish, etc.
1
by: DR | last post by:
how to determine what language a string is written in? is there any method to take a string and return what language it is in? e.g. english, hindi, spanish, etc.
2
by: paragdi | last post by:
Hi Experts! I am developing heavy mathematical engineering windows application in VB.NET (VS2005) with MSAccess Db. This application has resource files in English, Spanish and German Language. I...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.