On Fri, Nov 05, 2004 at 01:45:25PM +0100, Henrik Grubbström (Lysator) @ Pike (-) developers forum wrote:
Yes, so how do you know that data you have inserted with the non *16 functions won't be extracted with some *16 function?
I don't know, and sqlite doesn't too. There will be attempt to make conversion from UTF-8, if *16() function is used, obviously, it may fail - but there is nothing that we can do about this - invalid data may be inserted outside Pike as well, so Pike conversion will fail too. That's why option to turn conversion off is more good than evil (terrible things happen when utf8_to_string() fails inside SQLite module on query processing - I tried this already).
Regards, /Al