UTF-8

From: Martins Mihailovs <martins(dot)mihailovs(at)europrojects(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: UTF-8
Date: 2006-10-06 09:44:43
Message-ID: 4526258B.8010707@europrojects.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I'm using PgSQL for a 3 years for web applications, but not only. But
the main problem is in encoding. My web applications are used by
international (mostly 3 languages: latvian (LATIN7), english and
russian). The best (mostly) solution is to use UTF-8, but there are a
lot of problems. The main problem is in searching (tsearch2, lower,
upper, e.c.) and sorting.

I would be a glad to hear your solutions, experience in web application
with multi languages (searching with indexing, sorting and others
problems with multi byte encoding).

For developers: what are your future plans about UTF-8 in Postgres?

thanx
Martins

Responses

  • Re: UTF-8 at 2006-10-09 10:41:59 from Martijn van Oosterhout

Browse pgsql-general by date

  From Date Subject
Next Message Hugo 2006-10-06 12:49:20 Re: how to check SQLSTATE
Previous Message Richard Huxton 2006-10-06 08:56:32 Re: Two efficiency questions - clustering and ints