[Fwd: Re: Problem with collation/character data ordering]

Article View: pl.comp.lang.python

Article #13643

Back to pl.comp.lang.python Previous Next

#13643

From: Jarek Zgoda
Date: Wed, 25 Jan 2006 19:40

24 lines
1761 bytes

Poniżej jest odpowiedź on maintainera PySQLite na temat ostatnich
problemów z sortowaniem danych tekstowych w wynikach zapytań do SQLite3.

Jarek Zgoda wrote:
> I use PySQLite 2.0 and my unicode is not ordered properly in select
> result. Following script produces output, that suggests that "binary"
> (by byte value) sorting is used, instead of locale-specific sorting of
> character data (as defined by LC_COLLATE):

Yes, I believe that's SQLite's default, unless you register a collation.
And pysqlite hasn't wrapped SQLite's collation API yet.

> Is there anything I can do to receive character data properly ordered
> using 2.0?

Unfortunately, nothing reasonable just yet.

Implementing support for colations is the next thing on my TODO list
though after getting the current quirks with the 2.1 release fixed.

-- 
Jarek Zgoda
http://jpa.berlios.de/

Technical Details

Message-ID: <dr8kad$bt7$1@nemesis.news.tpi.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.rmf.pl!agh.edu.pl!news.agh.edu.pl!newsfeed.silweb.pl!newsfeed.tpinternet.pl!nemesis.news.tpi.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.rmf.pl!agh.edu.pl!news.agh.edu.pl!newsfeed.silweb.pl!newsfeed.tpinternet.pl!nemesis.news.tpi.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail
From: Jarek Zgoda <jzgoda@o2.usun.pl>
Newsgroups: pl.comp.lang.python
Subject: [Fwd: Re: Problem with collation/character data ordering]
Date: Wed, 25 Jan 2006 20:40:45 +0100
Organization: tp.internet - http://www.tpi.pl/
Lines: 24
Message-ID: <dr8kad$bt7$1@nemesis.news.tpi.pl>
NNTP-Posting-Host: dsx106.neoplus.adsl.tpnet.pl
Mime-Version: 1.0
X-Trace: nemesis.news.tpi.pl 1138218125 12199 83.24.235.106 (25 Jan 2006 19:42:05 GMT)
X-Complaints-To: usenet@tpi.pl
NNTP-Posting-Date: Wed, 25 Jan 2006 19:42:05 +0000 (UTC)
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051013)
X-Accept-Language: pl, en-us, en
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit