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. > 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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
