Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD

Adam PAPAI <adam(dot)papai(at)bsdsupportservice(dot)hu> writes:

> FreeBSD titanium 8.1-RELEASE FreeBSD 8.1-RELEASE #0: Mon Jul 19 02:36:49
> UTC 2010 root(at)mason(dot)cse(dot)buffalo(dot)edu:/usr/obj/usr/src/sys/GENERIC amd64
>
> Tested PgSQL versions are: 8.4 and 9.0.3 (fresh install using ports)

Did you try ICU patch? IMHO it can help with your problem. But i am not sure
how it is stable.

# cd /usr/ports/databases/postgresql84-server
# make config
┌────────────────────────────────────────────────────────────────────┐
│ Options for postgresql-server 8.4.5_2 │
│ ┌────────────────────────────────────────────────────────────────┐ │
│ │[X] NLS Use internationalized messages │ │
│ │[ ] PAM Build with PAM support (server only) │ │
│ │[ ] LDAP Build with LDAP authentication support │ │
│ │[ ] MIT_KRB5 Build with MIT's kerberos support │ │
│ │[ ] HEIMDAL_KRB5 Builds with Heimdal kerberos support │ │
│ │[ ] OPTIMIZED_CFLAGS Builds with compiler optimizations (-O3) │ │
│ │[X] XML Build with XML data type (server) │ │
│ │[X] TZDATA Use internal timezone database (server) │ │
│ │[ ] DEBUG Builds with debugging symbols │ │
│ │[X] GSSAPI BUild with GSSAPI support │ │
==>│ │[ ] ICU Use ICU for unicode collation (server) │ │
│ │[X] INTDATE Builds with 64-bit date/time type (server)│ │
│ │ │ │
│ │ │ │
│ │ │ │
├─└────────────────────────────────────────────────────────────────┘─┤
│ [ OK ] Cancel │
└────────────────────────────────────────────────────────────────────┘

--
Sergey Burladyan