Hi all,
I would like to ask if enabling utf8 encoding during development will affect the existing database file. It happens that I didn't enable utf8 when my project started, but now I want to make sure that my sqlite library supports Unicode data.
I have tested it with an existing database file and it seemed to be working fine. If so, what's the practical difference between the encoding used by sqlite? Does it only affect all newly inserted data? And how well does sqlite in iso8859 encoding handle Unicode data?
Thanks in advance,
Selwyn
