Skip site navigation (1) Skip section navigation (2)

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

From: Sergey Burladyan <eshkinkot(at)gmail(dot)com>
To: Adam PAPAI <adam(dot)papai(at)bsdsupportservice(dot)hu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD
Date: 2011-02-12 23:04:24
Message-ID: 8762sox3bb.fsf@home.progtech.ru (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

pgsql-bugs by date

Next:From: Edwin GiraldoDate: 2011-02-14 04:32:49
Subject:
Previous:From: Simon RiggsDate: 2011-02-12 14:50:14
Subject: Re: [PATCH] crash in 9.1's psql:describeOneTableDetails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group