On Fri, Oct 9, 2015 at 5:08 AM, Cecil Westerhof <cldwesterhof at gmail.com> wrote:
> When I use ORDER BY an ? comes after a z. Is it possible to make an ? come > after a z? > > If it is important I am using SQLite 3.8.6 and Python 3.4.1. > > -- > Cecil Westerhof > > ?I am unsure of how to do this _exactly_ as you want, but I am fairly sure what you need is the COLLATE phrase in the ORDER BY: SELECT column_name FROM table ORDER BY colum_name COLLATE collation_name ASC? The difficulty is in determining what "collation_name" needs to be. You may need to create your own. Some pages on the SQLite site which might help: ?http://sqlite.org/lang_select.html ?http://sqlite.org/syntax/ordering-term.html? https://www.sqlite.org/datatype3.html#collation https://www.sqlite.org/c3ref/create_collation.html I don't have the slightest idea if this sort of thing can be used with the supplied "sqlite3" program. It seems to be designed to be used by C programs. I've never used SQLite from Python. -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown