[sqlite] How is the name of the db file is identified?

[Simon Slavin]

On 28 Dec 2015, at 2:02am, Igor Korot  wrote:

> Is it possible to save the SQLite DB file whose name contains some Unicode
> characters?

The filename you pass to sqlite3_open_v2() should be encoded in UTF-8.
The filename you pass to sqlite3_open16() should be encoded in UTF-16.

Both of these work correctly in SQLite.  If your programming language, 
operating system and file system handle them correctly then you should have no 
problem using them for correctly encoded Unicode text.

> Have such a character in the table name?



Variants of _prepare() handle text in UTF-8 and UTF-16.  There's nothing in 
SQLite which restricts item names to ASCII.

Simon.

[sqlite] How is the name of the db file is identified?

[Igor Korot]

Hi, ALL,
Is it possible to save the SQLite DB file whose name contains some Unicode
characters?
Have such a character in the table name?

Thank you.