If I understand what you mean by 'ansi', UTF8 is a superset of it. So just go ahead and use the UTF8 interface with your strings as they are, things will probably work fine.
--- hubdog <[EMAIL PROTECTED]> wrote: > Now I want to use store and read utf string in sqlite3. > Now , I need encode my text in utf8 and pass them as insert sql to a > utf8 encoding sqlite database and > then I query the database to get the string inserted previously and > manully decode the string from utf8 to ansi to display them. > Now it looks like the encoding and decoding work all done by myself. So > I confused that what is meaning with > the utf8 encoding sqlite database, what is role of sqlite database in > processing the utf string? > __________________________________________ Yahoo! DSL Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com