Gilles Ganault <[EMAIL PROTECTED]> wrote: > Using Aducom's free wrapper for Delphi, when > using accents in a field, they're turned into (I assume) Unicode: > > déjà vu, caché, voilà -> déjà vu, caché, voilà !
This does look like UTF-8 encoded string - misinterpreted to be in Latin-1 codepage. > To be able to tell if it's the wrapper or SQLite > itself, is there a function I should call when > using accented characters, or does SQLite not care a bit? SQLite accepts (and returns) strings in either UTF-8 or UTF-16 encoding. If you have a string in any other encoding, you would have to convert it to one of those before passing it to SQLite (and convert back when retrieving from SQLite). Igor Tandetnik
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users