Re: localization design for DB structures? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: localization design for DB structures?
Date
Msg-id 20001207134221.A26804@gruby
Whole thread Raw
In response to localization design for DB structures?  (Isaac <Isaac@UNSTOPPABLE.com>)
List pgsql-general
On Wed, Dec 06, 2000 at 10:33:53AM -0600, Isaac wrote:
> We also want to have translations into other languages available for these
> documents (although not all of them will be translated).  Have others set up
> a structure like this before? I'm looking for some guidance on how to set up
> the tables so that the document only shows up once in a list of all
> documents (or searches), but the user gets the title and content based on
> the language they're using (and also when viewing the document in "your"
> language, you can see which other translations are available).

my first idea:
just add another field to the text's table with language symbol, and than build
request just documents which are in the language you need.

depesz

--
hubert depesz lubaczewski
------------------------------------------------------------------------
     najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
      jest niesamowita wręcz łatwość unikania kontaktów z nim ...

pgsql-general by date:

Previous
From: "Vilson farias"
Date:
Subject: little question
Next
From: Michael Meskes
Date:
Subject: Re: ECPG could not connect to the database.