Author ezio.melotti
Recipients William.D..Colburn, ezio.melotti, terry.reedy
Date 2012-12-30.16:32:42
SpamBayes Score -1.0
Marked as misclassified Yes
Message-id <1356885162.46.0.928429558313.issue16783@psf.upfronthosting.co.za>
In-reply-to
Content
> Treating invalid data as sometimes valid and sometime as invalid is a problem. 

What is valid is defined by your application.  AFAIU sqlite3 defaults to utf-8, but it's able to work with latin1 data as well.  The fact that you are mixing utf-8 and latin1 is an error in your application, and while it might be nice if sqlite3 warned you about it, it's not necessarily its responsibility.  Even thought it's a really bad idea, you might want to store data with different encodings and still being able to retrieve them using the right text_factory.

However while trying to reproduce the issue I noticed a possible inconsistency and reported it on #6010.
History
Date User Action Args
2012-12-30 16:32:42ezio.melottisetrecipients: + ezio.melotti, terry.reedy, William.D..Colburn
2012-12-30 16:32:42ezio.melottisetmessageid: <1356885162.46.0.928429558313.issue16783@psf.upfronthosting.co.za>
2012-12-30 16:32:42ezio.melottilinkissue16783 messages
2012-12-30 16:32:42ezio.melotticreate