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