Hello Nickye, I insert strings with "." all the time. In fact I'd say most insertions I do have "."s in them so, I don't think there's an inherent problem in Sqlite. I convert everything to UTF8 before I insert though the UTF8 of "." is ".".
C Monday, July 15, 2013, 3:13:46 PM, you wrote: nmr> Hello, nmr> Prepared statement SQL: "INSERT INTO tbl VALUES(?1);" nmr> Column type:TEXT nmr> String to bind (ASCII, zero terminated): "abcd.ef" nmr> nBytes parameter: -1 nmr> destructor parameter: SQLITE_STATIC nmr> Result after call sqlite3_step: "abcd" nmr> With nBytes==(len(String)) there's no problem, result=="abcd.ef" nmr> But then there's no way to bind parameter only once with the same text nmr> buffer. nmr> ni...@mail.ru nmr> _______________________________________________ nmr> sqlite-users mailing list nmr> sqlite-users@sqlite.org nmr> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
