> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Pavel Ivanov > Sent: Thursday, December 16, 2010 2:53 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Troubleshooting... > > > 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
Thank you Pavel. I am using SQLite3.exe to query the data with standard select statements (select * from table). Is there some setting within SQLite3 that I should be manipulating to provide me UTF8 output? The last four fields lead me to believe that my problem may be up front, on input. They accurately reflect the values that I am storing. The only difference between them and the earlier fields is that they are integer while the rest is text. R, John > > On Thu, Dec 16, 2010 at 3:35 PM, john darnell > <john.darn...@walsworth.com> 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 > johnamdarn...@gmail.com<mailto:johnamdarn...@gmail.com> > > > > 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 > > 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
