Thanks, Pavel. I will do this. R, John
> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Pavel Ivanov > Sent: Friday, December 17, 2010 9:22 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Troubleshooting... > > > 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? > > I'm not strong in that but I believe your settings should be not in > SQLite3 but in Windows. Try to search the internet for Windows > terminal encoding. > Meanwhile to check that your database contains what you want try to > redirect all output from sqlite3.exe to some text file and then view > it in notepad or browser. They can understand UTF-8 encoding pretty > well. > > > Pavel > > On Thu, Dec 16, 2010 at 4:47 PM, john darnell > <john.darn...@walsworth.com> wrote: > > > > > >> -----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 > > > _______________________________________________ > 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