Kevin Turner <kevin.j.tur...@gmail.com> wrote: > According to the sqlite FAQ, once an encoding has been set for a database, > it cannot be changed. Fair enough. But is it possible to *recreate* an > existing database and set the encoding type before the create table > statements are run?
I'm not sure what you mean by "recreate the existing database". You can create a new database by simply calling sqlite3_open on a file name for which the actual file doesn't exist. Then, you can run a PRAGMA statement to set the encoding of this database, before any table is created. Once the first table is created, the encoding is set in stone and cannot be changed. > I tried doing this to the table that uses UTF-16le: Encoding is the property of the database, not of each individual table. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users