I suggest you try using wchar_t* or std::wstring as std::string is not Unicode afaik.
Regards, Jonas On Thu, Dec 16, 2010 at 2:40 PM, Ming Lu <ming...@xenovation.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users