On 8/4/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Cory Nelson" <[EMAIL PROTECTED]> wrote:
> On 8/3/06, RohitPatel9999 <[EMAIL PROTECTED]> wrote:
>
> I recommend using utf-16 in the database - sqlite doesn't fully
> support utf-8, and some things may give unexpected results if you use
> it.
>
Oh really? What exactly is missing from SQLite's UTF-8 support?
Correct me if I'm wrong but from what I understand SQLite supports
storing and converting between UTF-8 and UTF-16, but that is where the
support stops. It is wrong (in my opinion) to claim UTF-8 support, at
least without a clear upfront warning, when that's all it offers.
IE, using memcmp() to compare strings. I've been bitten by this
before, with SQLite producing unexpected results when using UTF-8.
Using UTF-16 has worked more reliably in my experience.
--
D. Richard Hipp <[EMAIL PROTECTED]>
--
Cory Nelson
http://www.int64.org