-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Chad Woolley wrote: > We recently upgraded to sqlite3, and I cannot figure out how to get a > TEXT type field to sort numerically (it's for a Trac report). For > example, it is sorting 10,100,20,200 instead of 10, 20, 100, 200. > > Here's an example. Anyone know how I can address this problem? > Thanks in advance...
You could solve it with a custom collation. Currently only possible with the SVN version of pysqlite though, which will become pysqlite 2.2.0 in the not too-distant future. - -- Gerhard -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFD467JdIO4ozGCH14RArxpAJ9kVa42lD7YrW2GXMDL+yI4HplmugCeLLy+ g/Juh77VlVqHHGqqiZ6Isf0= =5OJa -----END PGP SIGNATURE-----
