> 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
