Re: [GENERAL] Internationalization

2009-04-11 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you Sam for the valuable input! Best regards, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Sam Mason wrote: > On Sat, Apr 11, 2009 at 02:47:53AM +0100, Pedro Doria Meunier wrote: >> Actually what I have is a fully internationa

Re: [GENERAL] Internationalization

2009-04-11 Thread Sam Mason
On Sat, Apr 11, 2009 at 02:47:53AM +0100, Pedro Doria Meunier wrote: > Actually what I have is a fully internationalized site by means of > getttext. > *Some* of the content comes from the PGSQL database where 2 tables > relation with others (namely for sensor data description). Why not continue u

Re: [GENERAL] Internationalization

2009-04-10 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Justin, First of all thank you for your input. :) Actually what I have is a fully internationalized site by means of getttext. *Some* of the content comes from the PGSQL database where 2 tables relation with others (namely for sensor data descript

Re: [GENERAL] Internationalization

2009-04-10 Thread Justin
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

[GENERAL] Internationalization

2009-04-10 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Li

Re: [GENERAL] Internationalization

2004-06-30 Thread Dennis Gearon
Tom Lane wrote: Dennis Gearon <[EMAIL PROTECTED]> writes: Tom Lane wrote: The indexes on the shared system tables (eg, pg_database) are the only issue here. One possible solution is to require that no locale-aware datatypes ever be used in these indexes. I think right now this is true because "na

Re: [GENERAL] Internationalization

2004-06-30 Thread Tom Lane
Dennis Gearon <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> The indexes on the shared system tables (eg, pg_database) are the only >> issue here. One possible solution is to require that no locale-aware >> datatypes ever be used in these indexes. I think right now this is true >> because "name

Re: [GENERAL] Internationalization

2004-06-30 Thread Tom Lane
Dennis Gearon <[EMAIL PROTECTED]> writes: > Is there anyway for a single statement to access more than one database? > Could a query, regexes, etc be facing indexes in different > encodings/sorting collations if different databases in a cluster had > different encodings/collations? The indexes o