multi-languages in a table

From: "YL" <elim(at)pdtnetworks(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: multi-languages in a table
Date: 2005-06-23 17:43:24
Message-ID: 002b01c5781b$0eba55f0$0800a8c0@grace
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm migrating from mysql to postgresql.
I've several (mysql)tables with multi-language columns:

descript, descript_gb, descript_b5, descript_sp

they store the record's description in
English, SimplifiedChinese, TraditionalChinese and Spanish respectively.

I don't know if this will work in postgresql: I need to query those columns
(one language at a time). And I hope the contents in those columns
can be displayed in web (one language at a time) easily.

Any suggestions? Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-06-23 17:45:34 Re: Corrupted index
Previous Message Tom Lane 2005-06-23 17:42:23 Re: TX semantics backward compatibility