Re: [sqlite] SQLite3 Error: Unable to open database file when file path has accents (e.g. é or è)

2018-05-08 Thread J Decker
On Tue, May 8, 2018 at 2:11 PM, Richard Hipp  wrote:

> On 5/8/18, Francis Kus  wrote:
> > I am able to open my database file if the path contains no accents.
> However,
> > if I change even one letter to an accented letter (e.g. replace 'e' with
> > 'é'), the database does not open and I get the error message "unable to
> open
> > database file".
>
> The argument to sqlite3_open() need to be UTF-8.  What encoding are you
> using?
>
and what system?


>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> 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


Re: [sqlite] SQLite3 Error: Unable to open database file when file path has accents (e.g. é or è)

2018-05-08 Thread Richard Hipp
On 5/8/18, Francis Kus  wrote:
> I am able to open my database file if the path contains no accents. However,
> if I change even one letter to an accented letter (e.g. replace 'e' with
> 'é'), the database does not open and I get the error message "unable to open
> database file".

The argument to sqlite3_open() need to be UTF-8.  What encoding are you using?

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] SQLite3 Error: Unable to open database file when file path has accents (e.g. é or è)

2018-05-08 Thread Francis Kus
Hi,


I am experiencing the following issue using SQLite 3.22.0:


I am able to open my database file if the path contains no accents. However, if 
I change even one letter to an accented letter (e.g. replace 'e' with 'é'), the 
database does not open and I get the error message "unable to open database 
file". This is particularly troublesome as our software has a large French 
client base, and user names tend to have accents in them.


Feel free to contact me for more information.


Thanks,


Francis Kus
Software Developer
Enero Solutions Inc
370 rue Guy, suite 207
Montréal, Qc
f...@enerosolutions.com
Tel: (514) 439 0941 x201
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users