Is there a sqlite gui that supports custom collations?
I have a custom collation sequence that I named NOCASE_UTF8 that I'm using in a couple sqlite dbs for an iPhone app I made. I would love to use a sqlite gui on my Mac to be able to manage my dbs rather than doing it all through my app's C code. I would also like to not have to roll my own gui tool JUST to handle this one problem.
I've tried a couple sqlite guis and neither one allows you to interact with collation unless I made a horrible oversight. I've tried using SQLite Manager and Base to insert rows into my tables that use the custom collation. Both just blow up with the error message "no such collation sequence: NOCASE_UTF8". I saw this answer for a list of guis but nothing I've read of the guis talks about custom collation support.
Am I just SOL or is there a sqlite gui out there with custom collation su开发者_开发百科pport?
I haven't tested it, but this solution is open source so if it doesn't support custom collation, you could add it yourself... if you dare.
http://code.google.com/p/phpliteadmin/
There are very few options for Mac OS in this category. I've always used the Firefox addon, but I've never used weird collations.
精彩评论