Re: Internationalization - Mailing list pgsql-general

From Justin
Subject Re: Internationalization
Date
Msg-id 49DF9E53.1030607@emproshunts.com
Whole thread Raw
In response to Internationalization  (Pedro Doria Meunier <pdoria@netmadeira.com>)
Responses Re: Internationalization
List pgsql-general
Pedro Doria Meunier wrote:
> Hi all,
>
> I'm wondering how to internationalize contents of a table, short of
> having a column for each language string ...
> Anyone with some experience to share? :)
>
> Regards,
> Pedro Doria Meunier
>
How about parent child table layout.  The child table has one record for
translation for each document.  something like this

Create table ParentDoc (
    docid serial,
    description text )

Create table ChildDoc (
    docid integer,
    doc_text text,
    short_description text,
    language text )

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Multiple character encodings within a single database/table?
Next
From: chinchu2005
Date:
Subject: ERROR: array subscript out of range