[EMAIL PROTECTED] wrote:
Hi,
I'm completely new to this list so I will now see how these mailing lists works.
We have been using sqlite 3.3.7 in a small Windows MFC (C++) application. The
database is placed in the Document and Settings\<username>\Application
Data\-folder. This worked fine until a user with the username Administratör
(Administrator in Swedish) showed up.
After some research, it seems that sqllite3_open strips away åäö. I also tried
the newer 3.6.1. Then I tried an old Demo program (CppSQLiteDemo) that uses a
sqlite3.dll noticeable smaller than the others, 218 kB and the datestamp is
from 2004-10-11. This one works just fine, and using this DLL in out
MFC-program then works fine too. At least for open files with file/folder-names
containing åäö, I haven't checked if something else has quit working.
So .... any ideas what I should do? Use the old DLL and start checking if
something else has quit, or is there another way to make use of the newer DLLs?
Sincerely
/Ann
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
The sqlite3_open* family of functions expects the name arguments in
UTF-8 encoding. I'm guessing that you don't pass them as UTF-8 but
encoded in your operating system's default code page, so sqlite3_open*
receives a string containing high (128+) character codes, tries to
interpret them as UTF-8 (which obviously fails) and does the right thing
in ignoring the invalid characters, which is why you're seeing them as
stripped off.
Please make sure that the strings you are passing are encoded in UTF-8.
--
Multumesc,
Mihai Limbasan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users