C_LOCALE vs. UTF8

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: C_LOCALE vs. UTF8
Date: 2004-06-15 02:55:06
Message-ID: 40CE650A.5000607@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HMMMMmmmm......,

There was a post running about using C_LOCALE is the only way to use
LIKE, and I put something similar to the below in comment to it. It
never showed up on the list. Oh well.

If I wanted a multinational database capable of many langauges,and
wanted the most functionality of sorts, order bys, indexes, LIKE, etc,
what is the best encooding?
I would have THOUGHT it would be UTF8, but maybe C_LOCALE?

Is there a chart somewhere showing the main differences between using
C_LOCALE and any other encoding? A nice simple table in the manual
would be really nice. If you give me the particulars, I'll write the table.

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2004-06-15 03:42:24 Re: Can you help me with this query?
Previous Message Tom Allison 2004-06-15 01:51:34 Re: perl access