SQLite includes a Tcl API. Tcl does all these conversions with ease. See the encoding convertto/convertfrom commands and fconfigure.
On Tuesday 05 December 2006 20:42, Nicolas Williams wrote: > On Tue, Dec 05, 2006 at 06:53:28PM +0100, Marten Feldtmann wrote: > > Perhaps it would be nice to change sqlite3 in that way, that (when > > columns with storage class text) these columns are converted to the host > > platform code page. But actually even in that situation you may have > > strings, which are not displayable on your screen - because you have no > > suitable font. > > No, but having built-in functions that can do codeset conversion would > be nice. > > -- convert from the default SQLite codeset/encoding (UTF-8) to a given > -- codeset > select iconv(foo, NULL, 'ISO-8859-1') from ...; > > -- convert to a codeset given by some row column > select iconv(foo, from_cs, to_cs) from ...; > > -- convert to the current locale's codeset > select iconv(foo, NULL, NULL) from ...; > > And functions for Unicode normalization and what not would be nice as > well. > > Nico ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
