From: | "Tony Lausin" <tonylausin(at)gmail(dot)com> |
---|---|
To: | "Tomi NA" <hefest(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is PostgreSQL an easy choice for a large CMS? |
Date: | 2006-04-30 19:23:31 |
Message-ID: | 296cdcaf0604301223u7d3c6377w73d5646707f8928@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> In my opinion, postgresql is not the way to go when building a cMS
> simply because of the way it handles strings.
> A CMS should be language/region agnostic i.e. supporting any chosen
> locale subset, rather then just one locale, as postgresql does. You
> can throw UTF-8 at the problem and it will enable data
> storage/retrieval, but you'll still be stuck with incorrect text
> ordering/sorting in any locale but the default.
> Truth be told, I don't know of a single RDBMS which handles this issue
> gracefully, but with postgresql, your basically stuck with a single
> language/locale.
> On the other hand, if you don't need multilang support, you'll find
> that postgresql is generally great to program and use.
>
> Tomislav
Hello Tomislav,
In my case, UTF-8 is a must. The site contextually will be directed to
North Americans, although I do anticipate that many users will from
time to time insert text in their own native languages. I myself
certainly may use non-latin characters from time to time (cyrillic),
so I find UTF-8 to be the best common bridge.
Regards,
Anthony
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Lausin | 2006-04-30 19:32:53 | Re: Is PostgreSQL an easy choice for a large CMS? |
Previous Message | Tony Lausin | 2006-04-30 19:14:26 | Re: Is PostgreSQL an easy choice for a large CMS? |