Hello Martin, thank you very much for your suggestion.
i tried again with the firefox plugin works very well with the umlaut.(i update the feld with a "ä", it can been shown correctly). in my code: std::string strText = GetWindowsTitle(...); the GetWindowsTitle occupied sometime with the umlaut. so how will you do, if you want save std::string into sqlite with keeped umlaut? thanks a lot best regards ming On 16.12.2010 14:26, Martin Engelschalk wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
