Simon, On Thu, Jun 23, 2016 at 6:14 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Jun 2016, at 10:53pm, Igor Korot <ikoro...@gmail.com> wrote: > >> So what I'm trying to do is to see what will happen if I get a >> database with the German character(s) >> or Asian characters in the table/field name and they will be entered >> the same way. > > All table/field names in a SQLite database are Unicode. They can have > characters in any language (or several languages) in and the will all work > fine. Unless the program which created those databases had a bug in.
OK, so are they UTF-8, UTF-16 or something else? And I'm talking the default one - the one which is set when I just open the shell tool and say CREATE TABLE() on the empty database. Knowing this will help with the exception I am seeing. > >> My program will probably try to open on the same machine or at least >> on the machine with the same locale, >> but nevertheless, it should be possible to get the information I want. > > Your locale should not have any effect on what goes into a SQLite database. > All strings must be translated into Unicode before they are passed to the > SQLite API. And by 'All strings' I include SQL commands like the ones which > create tables and define field names. > > If your software works correctly then > > * Your locale has no effect on entity names in a SQLite database > * Your code page has no effect on entity names in a SQLite database > > If either of these are not true then there is a fault with your programming > and it should be fixed. And it is not. As you can see I presume that whatever I got as a table name is UTF-8 and then I am converting it to std::wstring. Thank you. > > Simon. > _______________________________________________ > 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
