C++ sqlite3_open_v2 function fails to open DB file when DB path has special char(ø) in it

Neelesh Kalani 26

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 ø?

David Lowndes 4,711 Reputation points

2021-11-03T11:33:34.657+00:00

Do you convert the name to UTF-8?
"C:\MySÃ¸LiteDb.sqlite"
Neelesh Kalani 26 Reputation points

2021-11-03T11:42:19.307+00:00

No I don't - how do we do that? Would that fix?
YujianYao-MSFT 4,281 Reputation points Microsoft Vendor

2021-11-04T01:59:10.173+00:00

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.

Accepted answer

David Lowndes 4,711 Reputation points

2021-11-03T11:58:12.177+00:00

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.
Please sign in to rate this answer.

1 person found this answer helpful.
Neelesh Kalani 26 Reputation points

2021-11-08T17:26:29.48+00:00

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);
Sign in to comment

C++ sqlite3_open_v2 function fails to open DB file when DB path has special char(ø) in it

0 additional answers