Re: string_to_utf8() behavior on non-wide strings

On Thu, Nov 04, 2004 at 09:05:01PM +0100, Marcus Comstedt (ACROSS) (Hail Ilpalazzo!) @ Pike (-) developers forum wrote:

are character sequences), since Oracle had very firm opinions on what a character is.

sqlite (the library) doesn't have any opinion of what a character is (unless used in caseless comparisons). There is no strict typing (that's feature, not a bug). It accepts strings - a sequences of 8-bit characters (16-bit characters will be converted using UTF-8 encoding, if used).

Even integers and floats are strings in sqlite (it implies that if any given number cannot be converted to "native" 8-128 bit integer or 64-bit float, it will be stored as string).

Regards, /Al