The sqlite shell, at least historically, has I think not accounted for text encoding and simply passed whatever it reads from the console into the database.
There has been recent changes in this area since your last email on the subject, for sqlite 3.12.0. What version are you using, Igor? -Rowan On 24 June 2016 at 12:04, Igor Korot <ikoro...@gmail.com> wrote: > Kevin, > > On Thu, Jun 23, 2016 at 11:39 PM, Kevin Benson <kevin.m.ben...@gmail.com> > wrote: > > -- > > -- > > -- > > --Ô¿Ô-- > > K e V i N > > > > On Thu, Jun 23, 2016 at 10:38 AM, Igor Korot <ikoro...@gmail.com> wrote: > > > >> Hi, Clemens, > >> > >> On Thu, Jun 23, 2016 at 10:33 AM, Clemens Ladisch <clem...@ladisch.de> > >> wrote: > >> > Igor Korot wrote: > >> >> I am trying to find out why the following code fails to do proper > >> conversion. > >> >> It works if the tableName have "abcd", but fails if it has "abcß" > (the > >> >> German letter for the "ss" (looks like Greek letter beta)). > >> >> > >> >> const unsigned char *tableName = sqlite3_column_text( stmt, 0 ); > >> >> pimpl->m_tables[m_catalog].push_back( Table( myconv.from_bytes( > (const > >> char *) tableName ), fields, foreign_keys ) ); > >> > > >> > What are the byte values in tableName? > >> > >> I have no idea. > >> I just did ALT+225 in the SQLite shell during the CREATE TABLE command. > >> > >> Thank you. > >> > >> > > Have you tried changing to Windows UTF-8 codepage by issuing > >>chcp 65001 > > at the Windows command prompt, before starting the SQLite shell and doing > > ALT+225 during the CREATE TABLE command ? > > No, I didn't. > But everything should work independently of what code page is being used? > My interface to the DB is based on the std::wstring. So, if someone > will create the DB > inside the shell and then create tables and name them using Chinese, > why I should change > something before doing it, just to satisfy one software? > > Thank you. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
