On 10/21/10 10:17 AM, John Fabiani wrote: > On Thursday, October 21, 2010 09:50:19 am Paul McNett wrote: >> On 10/21/10 9:47 AM, Paul McNett wrote: >>> Shouldn't Dabo encode/decode to/from an SQLite backend using the encoding >>> set in the sqlite database (most like 'UTF-8'), not the encoding >>> returned by dabo.getEncoding() (most likely "1252" on Windows)? >> >> If so, we can change Dabo to use the database encoding as set in the SQLite >> database using "PRAGMA encoding;": >> >> http://www.sqlite.org/pragma.html#pragma_encoding >> >> Paul > > How does this work if the database is saving English and the app is written in > Spanish.
It doesn't apply, because we are talking about character encodings, not spoken languages. SQLite *only* supports UTF-8 and various UTF-16 variants[1]. Therefore, we should be saving UTF-8 or UTF-16 to sqlite (not 1252 or anything else). [1] It actually allows people to extend this at the C-API layer but I don't think that's important for this discussion Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/[email protected]
