While developing Win32/MFC Application (with Visual C++ 6.0)
- Application uses SQLite DB for it's data storage
- Application must run on most windows (Windows 98, ME, NT, XP, 2000)
- User should be able to copy Database from one PC to another PC (one PC may
be running Windows 98 and another one Windows 2000 or XP)
In this case, which encoding should be used for SQLite database ?
Default encoding, UTF-8 or UTF-16 ????
FWIW, if Windows is your only target, UTF-16 is the best choice for
you, because wchar_t is in UTF-16 on Windows and you can avoid some
string conversion in this case, while still be able to enable the
stuff for other OSes as soon as there is a need for it.
--
Alexei Alexandrov
