This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 87%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
I am trying to open a SQLite DB connection using sqlite3_open_v2 function but it fails to open the connection when DB file path has special char(ø) in it. Say something like "C:\MySøLiteDb.sqlite". Everything works fine if DB path doesn't have a special char(ø) in it.
It works with sqlite3_open16 method but then I have to change the DB encoding to UTF-16 otherwise it doesn't return any tables back.
How can I open a SQLite DB connection with sqlite3_open_v2 method when DB file path has special char in it such as ø?
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 12%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
Do you convert the name to UTF-8?
"C:\MySøLiteDb.sqlite"
No I don't - how do we do that? Would that fix?
Hi @Neelesh Kalani ,
Thanks for taking time to report this problem with us. Since your question is more related to SQLite, you could go to SQLite Forum for support.
Answer accepted by question author
The API does say that the parameter should be UTF-8, so converting to that would be the obvious thing to try.
Under Windows, the underlying API to use is WideCharToMultiByte, but depending on your source, there are several different wrappers you can use, such as AtlUnicodeToUTF8; more discussion here.
Converting to UTf 8 worked. Thank you so much.
Here is the code I used to convert:
//Get the required length of the utf byte array
int utfByteArrayLength = WideCharToMultiByte(CP_UTF8, 0, szFile, -1, NULL, 0, NULL, FALSE);
char * utf8 = new char[utfByteArrayLength];
//Convert to utf 8 using the byte array length
int j = WideCharToMultiByte(CP_UTF8, 0, szFile, -1, utf8, utfByteArrayLength, NULL, FALSE);