On Thu, Nov 04, 2004 at 06:50:01PM +0100, Henrik Grubbström (Lysator) @ Pike (-) developers forum wrote:
Conversion to UTF8 doesn't hurt anything (except space).
Unless input is UTF8 encoded already. That's what I am trying to tell during this discussion.
The user won't have to do anything, since the strings will be decoded on extraction.
The user must not provide UTF8 encoded strings to module, otherwise those will be double-encoded.
In current implementation, any string which is 8-bit wide and inserted into sqlite using bindings, will be flagged as datatype "blob", which is not always good idea and may differ from user's intentions.
Regards, /Al