| Lists: | pgsql-admin |
|---|
| From: | Ransika de Silva <ransika(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Make the primary key a multilingual value |
| Date: | 2009-07-04 17:44:11 |
| Message-ID: | a5af5afc0907041044r45c032efs7733905cf5c3d606@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Hi all,
I have a requirement of storing multilingual words and hence planing to
utilize the Unicode support of the database tables. The question that I have
is, will there be a problem if I make the primary key of a table
multilingual, in the sense let's say we are storing names of each country in
English, German, Sinhala (Language used in Sri Lanka) and Japanese in the
same table, so having the country name column to store different languages
will it be a problem?
We require to search the database for the matching names.
Thanks in advance for your time.
Regards,
Ransika De Silva
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Cc: | Ransika de Silva <ransika(at)gmail(dot)com> |
| Subject: | Re: Make the primary key a multilingual value |
| Date: | 2009-07-06 12:35:11 |
| Message-ID: | 200907061535.11412.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
On Saturday 04 July 2009 20:44:11 Ransika de Silva wrote:
> I have a requirement of storing multilingual words and hence planing to
> utilize the Unicode support of the database tables. The question that I
> have is, will there be a problem if I make the primary key of a table
> multilingual,
Not unless you create the problem yourself. :-) Shouldn't be a problem as far
as PostgreSQL is concerned.