Re: [sqlite] Using sqlite3_open or sqlite3_open16?

2006-04-25 Thread Roberto
Windows (NT, 2000, XP etc..) unicode strings are in UCS-2 (!= UTF-16) You should be calling SHGetSpecialFolderPathW (note the W at the end) with a 'wide' buffer for the "My Documents" directory, before converting this to UTF-8 and passing it to sqlite_open(). HTH. On 24/04/06, COS <[EMAIL PROTECTE

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

2006-04-24 Thread COS
Hi Jens, > If you're coding against the 'standard' Win32 APIs, Windows will send > you the strings in the character encoding specified by the either > the System or the current user settings. This has nothing to do with > unicode. However, for many roman characters, the standard Windows > code pa

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

2006-04-24 Thread Jens Miltner
Am 24.04.2006 um 14:51 schrieb COS: Hi Jens, - Original Message - From: "Jens Miltner" <[EMAIL PROTECTED]> To: Sent: Monday, April 24, 2006 5:30 AM Subject: Re: [sqlite] Using sqlite3_open or sqlite3_open16? Am 22.04.2006 um 15:48 schrieb COS: Thanks for the

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

2006-04-24 Thread Jay Sprenkle
> I tried to look for some information in the MSDN, without success. I'm > starting to look at SQlite code to find out how the conversion is made and > maybe I can simulate the same process before opening the file and choose the > proper way. If I remember correctly there are different subroutines

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

2006-04-24 Thread COS
Hi Jens, - Original Message - From: "Jens Miltner" <[EMAIL PROTECTED]> To: Sent: Monday, April 24, 2006 5:30 AM Subject: Re: [sqlite] Using sqlite3_open or sqlite3_open16? > > Am 22.04.2006 um 15:48 schrieb COS: > > Thanks for the info. I did have found

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

2006-04-24 Thread Jens Miltner
Am 22.04.2006 um 15:48 schrieb COS: Thanks for the info. I did have found in the manual that UTF16 is converted to UTF8 on Windows environments. But one little question: How would one know if the filename is in UTF8 or UTF16? You see, my little application is installed in PC's all around th

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

2006-04-22 Thread COS
Hi Christian, - Original Message - From: "Christian Smith" <[EMAIL PROTECTED]> To: Sent: Thursday, April 20, 2006 11:16 AM Subject: Re: [sqlite] Using sqlite3_open or sqlite3_open16? > On Thu, 20 Apr 2006, DBTools Software wrote: > > >Hi, > > >

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

2006-04-20 Thread Christian Smith
On Thu, 20 Apr 2006, DBTools Software wrote: >Hi, > >I have an application that needs to open a database in the users's personal >folder. I noticed that in some circunstances the sqlite3_open fail as the >filename is in UTF16 format. I don't know that in advance so I could open >the db with sqlite

[sqlite] Using sqlite3_open or sqlite3_open16?

2006-04-20 Thread DBTools Software
Hi, I have an application that needs to open a database in the users's personal folder. I noticed that in some circunstances the sqlite3_open fail as the filename is in UTF16 format. I don't know that in advance so I could open the db with sqlite3_open16. The question is: Is it safe to always us