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

Re: How strings are sorted by LC_COLLATE specifically?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Chang Chao <charleschung(dot)cn(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How strings are sorted by LC_COLLATE specifically?
Date: 2010-11-30 19:31:02
Message-ID: 1291145462.13957.10.camel@vanquo.pezone.net (view raw or flat)
Thread:
Lists: pgsql-sql
On tor, 2010-11-25 at 14:42 +0900, Chang Chao wrote:
> How strings are sorted when LC_COLLATE = ja_JP.UTF-8.
> I tried to read the documention on that,but there are just a few
> words,
> like LC_COLLATE determines string sort order,
> Is there a specific reference about this?
> So I can implement an equivalent string sort function in JAVA.
> because some of the sort logic is here.

The actual string comparison is done by the strcoll() function in the
operating system's C library.


In response to

Responses

pgsql-sql by date

Next:From: Isaac DoverDate: 2010-11-30 20:03:04
Subject: Re: indexing longish string
Previous:From: Isaac DoverDate: 2010-11-30 19:21:40
Subject: Re: indexing longish string

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