> If they are stored with wchar_t, then using the '16' APIs is
> probably easiest to use (ie sqlite3_open16, sqlite3_prepare16_v2, etc).

Just don't forget that wchar_t on some platforms (reportedly on Linux
for example) is 32-bit integer. So conversion between wchar_t and
UCS-2 encoding is not always as easy as you can think.

Pavel

On Fri, Aug 21, 2009 at 9:44 AM, Doug<pa...@poweradmin.com> wrote:
> Hi Erick --
>
> I can only help a little with #3.  How are your strings stored in your
> program?  If they are stored with wchar_t, then using the '16' APIs is
> probably easiest to use (ie sqlite3_open16, sqlite3_prepare16_v2, etc).
> That's what I do and all sorts of European and Asian customers don't have
> any issues with storing and retrieving local strings.  If you don't use the
> wide-char (16) APIs, you would need to explicitly convert your strings to
> UTF-8 (which is not the same as ASCII) before handing to SQLite.
>
> Doug
>
>
>> -----Original Message-----
>> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>> boun...@sqlite.org] On Behalf Of e...@sitadella.com
>> Sent: Thursday, August 20, 2009 4:21 PM
>> To: sqlite-users@sqlite.org
>> Subject: [sqlite] (no subject)
>>
>> Hi guys,
>>
>> This is my first post. I am creating a simple document archiving
>> program
>> for small businesses. I am creating it in a scripting language called
>> www.autohotkey.com. I intend to place the SQLite database file on a
>> network share and use sqlite.dll to access and manipulate it.
>>
>> In general, everything is on a relatively small scale: there will be
>> less
>> than 10 users who will occasionally interact with the database, there
>> will
>> be around 4 tables and based on experience with a similar system, I
>> don't
>> expect a total of more than 50000 records after a few years of use. The
>> client computers will be Windows XP or newer and the database file will
>> be
>> located on a network share on a Windows 2000 server or newer.
>>
>> 1. I have read that the file locking mechanisms on older windows
>> networks
>> are not very reliable and that it is not advisable to use SQLite on NFS
>> or
>> network shares. Given the robustness and efficiency of SQLite and the
>> low
>> frequency of use of my application, do I still need to worry about
>> placing
>> the database on a network share?
>>
>> 2. Should I modify any of the default settings to better suit this
>> environment?
>>
>> 3. I am having problems reading and writing international characters to
>> and from the database, specifically the norwegian characters æ, ø and
>> å.
>> If I use sqlite.exe to create a records containing æ, ø or å, I can
>> read
>> the record using sqlite.exe without any problems. Likewise, if I use
>> SQLiteSpy to create a record containing ø, æ or å I can read the record
>> using SQLiteSpy without any problems. But if I create a record in
>> sqlite.exe and try to read it with SQLiteSpy or vice versa, it doesn't
>> work as expected and the special characters are converted to all sorts
>> of
>> oddball symbols like squares and question marks. I assume this is
>> somehow
>> due to different ASCII/UTF encodings, but how can these problems be
>> avoided?
>>
>> 4. Select commands are case sensitive with æ, ø and å. Is there a
>> simple
>> workaround for this?
>>
>>
>> Regards,
>> Erik
>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to