Hello Ming, sqlite does nothing to transform data between codepages, and it assumes that data you insert is passed in UTF8. However, sqlite will acept any data and store it.
If the firefox plugin does not show you data correctly, then you problably did not pass correct UTF8 to sqlite. Can you check this? I just checked the firefox (0.6.5) plugin with my databases, it works correctly for me. Pictures / Attachments do not make it to the list. Martin Am 16.12.2010 14:17, schrieb Ming Lu: > Hello everyone, > > i am faceing a problem with unicode to save german umlaute in sqlite: > > here ist the problem: > > dev-envoriment: > Visual studio 2008 > SQLite 3.6.20 > > i used the sqlite c/c++ interface and open a db used sqlite3_open. > during the running of my application will the german-umlaut or other > symbol transported into the database. i use the SQLite Manager(firefox > plugin) to open the db and the umlaut cannot be correctly saved into the > database(see the pic) : > > -> it should be "รค". > > my question is, how can use the sqlite c/c++ interface to save the > unicode correctly into a sqlite database? > > thanks a lot > best regards > > Ming > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
