Re: localization design for DB structures?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
To: Isaac <Isaac(at)UNSTOPPABLE(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: localization design for DB structures?
Date: 2000-12-07 12:42:21
Message-ID: 20001207134221.A26804@gruby
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message JAMES 2000-12-07 12:50:15 Query problem
Previous Message Vilson farias 2000-12-07 12:40:34 little question