[sqlite] Re: UTF8

[Igor Tandetnik]

Cesar David Rodas Maldonado
<[EMAIL PROTECTED]> wrote:
I wanted to ask how can i know if a given text is UTF8 or ISO-8859-1?

You can't really. You need to have some metadata - some means outside 
the text itself to let you know what encoding the text is in.

E.g. a combination of two bytes C3 A5 can be interpreted as two 
characters å in ISO-8859-1, but it's also a valid UTF8 sequence 
representing Unicode character U+00E5  å . There's no way to tell from 
text alone.

Igor Tandetnik