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

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 specify it there?

Thanks,
Jason

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 specify it there?

   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.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

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 create the tables using the
> > .createTable() class method ??? how do I specify it there?
> 
>    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.

   Aha, it does, to some extent:
http://www.sqlite.org/pragma.html#pragma_encoding

   "It is not possible to change the text encoding of a database after
it has been created and any attempt to do so will be silently ignored."

   So you only need this PRAGMA once - before you create you database.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

On 18 February 2011 16:12, Oleg Broytman <ph...@ph...> 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 use UTF-8 (I just
like to be explicit).

Cheers,
Jason