Re: [SQLObject] Setting encoding on sqlite (on disk) DB

2011-02-18 Thread Oleg Broytman
On Fri, Feb 18, 2011 at 03:50:41PM +0800, Jason Heeris wrote: > When using MySQL with SQLObject, I can use a URI like: > "mysql://.../db?charset=utf8" to indicate the encoding. What's the > equivalent for SQLite? What if I create the tables using the > .createTable() class method ??? how do I speci

Re: [SQLObject] Setting encoding on sqlite (on disk) DB

2011-02-18 Thread Oleg Broytman
On Fri, Feb 18, 2011 at 11:12:29AM +0300, Oleg Broytman wrote: > On Fri, Feb 18, 2011 at 03:50:41PM +0800, Jason Heeris wrote: > > When using MySQL with SQLObject, I can use a URI like: > > "mysql://.../db?charset=utf8" to indicate the encoding. What's the > > equivalent for SQLite? What if I creat

Re: [SQLObject] Setting encoding on sqlite (on disk) DB

2011-02-18 Thread Jason Heeris
On 18 February 2011 16:12, Oleg Broytman wrote: >   Does SQLite support anything other than UTF-8? I think it's always > UTF-8 so you don't need (and actually, cannot) change anything. I thought it supported UTF-16 too, but uses UTF-8 by default. Presumably then, if I just leave it alone, it'll u