> Once I bind the data to the Insert statement, how can I look at the final > statement to see what I have done wrong when the statement does not work?
There's no way to do that. You should print what you bind yourself. For me it looks like you insert into database some UTF-8 string and then try to look at it in the terminal working in some other encoding and it thus unable to show your UTF-8 string correctly. Pavel On Thu, Dec 16, 2010 at 3:35 PM, john darnell <[email protected]> wrote: > IAW the SQLite book I purchased, I have incorporated data binding into my > “INSERT” statements, but neither of the two most important statements are > working…or rather, the first adds a record to the table, but it is mostly > junk, looking like this: > > > 4851||x|x|x||2|3|1|10 > 4852||ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■|ε■ε■ε■ε■ε■ε■ε■ε■ε|ε■ε■ε■ε■ε■ε■ε■ε■ε■ε||2|3|1|10 > 4853||x|ε■ε■ε■ε■ε■ε■ε■ε■ε|ε■ε■ε■ε■ε■ε■ε■ε■ε■ε||2|3|1|10 > 4854||ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■ε■|ε■ε■ε■ε■ε■ε■ε■ε■ε|ε■ε■ε■ε■ε■ε■ε■ε■ε■ε||2|3|1|10 > > And the second one publishes a self-generating statement that the Insert > statement did not work. > > Once I bind the data to the Insert statement, how can I look at the final > statement to see what I have done wrong when the statement does not work? > > R, > John A.M. Darnell > Senior Programmer > Walsworth Publishing Company > Brookfield, MO > John may also be reached at > [email protected]<mailto:[email protected]> > > Trivia SF question: In the movie, THE MATRIX, just before Neo and Trinity > take a harrowing ride up an elevator shaft holding on to an elevator cable, > Neo mutters a single phrase. What is that phrase? > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
