Re: [sqlite] Default Encoding In Sqlite

2007-12-16 Thread Daniel Önnerby
Sorry.. meant English is NOT my primary language :) Daniel Önnerby wrote: I figure I'll keep it short since it's only for the FAQ. English is my primary language, but here my suggestion: Question: Does SQLite handle unicode? Short answer: Yes! Answer: SQLite handles unicode very well. SQLite

Re: [sqlite] Default Encoding In Sqlite

2007-12-15 Thread Daniel Önnerby
I figure I'll keep it short since it's only for the FAQ. English is my primary language, but here my suggestion: Question: Does SQLite handle unicode? Short answer: Yes! Answer: SQLite handles unicode very well. SQLite stores texts in either UTF-16 or UTF-8 format depending on how the

Re: [sqlite] Default Encoding In Sqlite

2007-12-15 Thread drh
=?ISO-8859-1?Q?Daniel_=D6nnerby?= <[EMAIL PROTECTED]> wrote: > Unicode questions seems to come up at least once a week on the > mailinglist. Maybe there should be something about this in the FAQ or > the features page? > I will happily accept suggested text for such entries. -- D. Richard

Re: [sqlite] Default Encoding In Sqlite

2007-12-15 Thread Daniel Önnerby
Unicode questions seems to come up at least once a week on the mailinglist. Maybe there should be something about this in the FAQ or the features page? Trevor Talbot wrote: I wrote: The default storage encoding on disk is UTF-8, but it can be changed to UTF-16 with a PRAGMA. As

Re: [sqlite] Default Encoding In Sqlite

2007-12-14 Thread Trevor Talbot
I wrote: > The default storage encoding on disk is UTF-8, but it can be changed > to UTF-16 with a PRAGMA. As Igor reminds me, if you create the database file using sqlite3_open16() the default will be UTF-16 instead. You can still set it explicitly via a PRAGMA if you wish.

Re: [sqlite] Default Encoding In Sqlite

2007-12-14 Thread Trevor Talbot
On 12/14/07, Kalyani Phadke <[EMAIL PROTECTED]> wrote: > Whats default encoding in SQLite3 ? How does SQLite3 handles storing > Japanese/Chinese text in database? I know in SQL express/sql server I > have to use nVarchar/nchar/ntext datatypes to store Japanese/Chinese > text in database. It