You mean, to use sqlite c api (in some simple application) to read data from database and see are they in UTF-8 encoded?