Re: [sqlite] SQLite & ISO8859-x characters (Linux, C)

2008-10-16 Thread Zbigniew Baniewski
Wow, a whole lot of material... thanks. Starting to read it all... -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite & ISO8859-x characters (Linux, C)

2008-10-15 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Zbigniew Baniewski wrote: > How one should handle this? SQLite has UTF-8 by default. You seem to doubt being all Unicode is a good thing :-) Read this http://www.joelonsoftware.com/articles/Unicode.html > What C-function (Linux) could be

[sqlite] SQLite & ISO8859-x characters (Linux, C)

2008-10-15 Thread Zbigniew Baniewski
How one should handle this? SQLite has UTF-8 by default. This makes a bit of conversion necessary before INSERTion (and the opposite after SELECTion, and so on...) - am I right? Or perhaps it can be notified at C-level about client-encoding - and is able to convert on its own? What C-function