[sqlite] Japanese-Korean characters

Hi, Can we store/retrieve Japanese/korean characters in sqlite db ? Thanks, Pavan. -- ' Always finish stronger than you start *

Re: [sqlite] Japanese-Korean characters

UTF-8 (or Unicode) rules! Thanks for the quick reply. But, I havent understood. Can you be bit more clear ? Best Regards, Pavan. On 4/25/07, Tian-Jian Barabbas [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Pavan 提到: > Hi, > > Can we store/retrieve Japanese/korean characte

Re: [sqlite] Japanese-Korean characters

Hi Ralf, Thanks for the link. My OS is Linux. Is there something available on these lines for linux ? Best Regards, Pavan. On 4/26/07, Ralf Junker <[EMAIL PROTECTED]> wrote: Hello Pavan, >Can we store/retrieve Japanese/korean characters in sqlite db ? Yes, you can well do so,

[sqlite] License Queries

someone wants to share related to license. Thanks in advance, Pavan. -- ' Always finish stronger than you start *

Re: [sqlite] License Queries

the licensing issues of the modules which are accesing sqlite. Thanks, Pavan. On 4/26/07, P Kishor <[EMAIL PROTECTED]> wrote: you don't have to do anything. SQLite is in public domain. You can cook with it, make castles with it, become a billionaire (although, if you do, remember to give some

[sqlite] Locking queries

? Thanks, Pavan. -- ' Always finish stronger than you start *

Re: [sqlite] beginner

Hi Nishit, http://www.sqlite.org/quickstart.html This is a good link to start with. Thanks, Pavan. On 8/30/07, nishit sharma <[EMAIL PROTECTED]> wrote: > > Hi, > i m beginner to sqlite > can anybody send me a link which can help me > in building a

Re: [sqlite] beginner

You should link the library when you compile .It should be gcc test.c-l library name should be your sqlite shared library. Just check in /usr/lib directory Thanks, Pavan. On 8/31/07, nishit sharma <[EMAIL PROTECTED]> wrote: > > hey buddy can u tell me how to compile the C

Re: [sqlite] beginner

prepare sql query and pass it to sqlite3_exec Thanks, Pavan. On 9/3/07, nishit sharma <[EMAIL PROTECTED]> wrote: > > thanks for this help. i have done this... > my another problem is that i have multiple columns in my database and on > the > basis of > two columns( ha

Re: [sqlite] beginner

Also, just to add when you reply back with a different query to the list, pls post a seperate mail with a appropriate subject line so that more people might be interested to help you. Thanks, Pavan. On 9/5/07, Clay Dowling <[EMAIL PROTECTED]> wrote: > > Nishit, > >

[sqlite] Storing contacts list for each user

is the best way to store this data ?. Should i create different tables for each user, so hat at any point of time only one users data will be accessed ? Should i store all the information in one table and then acess it ? Thanks in advance, Pavan

[sqlite] Difference between sqlite and sqlite3

Hi, Can anyone tell me what is the difference between sqlite and sqlite3. Thanks, Pavan. -- ' Always finish stronger than you start *

Re: [sqlite] Storing contacts list for each user

.db [User2 will have table to hold contacts list] . . . /home/user/userN/userN.db [UserN will have table to hold contacts list] The idea is that at any point of time user1 should not access user2 details and vice-versa. Does it make sense conceptually and is it feasible technically ? Thanks, Pavan

Re: [sqlite] Storing contacts list for each user

Hi Paul, Thanks for the detailed reply... The app would be on these lines, download the phone book for several users onto the linux PC and give access to their downloaded phone books for reading at later time, each user should not see other user contacts list. Thanks, Pavan. On 2/15/07

[sqlite] UTF16 Encoding

Hi, When i tried to create the db file using API sqlite3_open16("test.db",) it creats the file name with some junk characters. The file name is correct if i use sqlite3_open("test.db",). Does it mean sqlite3 does not support UTF16 encoding ? or Am i missing some pack

Re: [sqlite] UTF16 Encoding

at does the 'L' mean in the API ? Thanks, Pavan. On 2/28/07, Nuno Lucas <[EMAIL PROTECTED]> wrote: On 2/28/07, Pavan <[EMAIL PROTECTED]> wrote: > Hi, > > When i tried to create the db file using API sqlite3_open16("test.db ",) > it creats the file name with some

Re: [sqlite] UTF16 Encoding

But I'm thinking you really want to do this anyway: Well, I have a requirement to store/retrieve UTF16 strings. The current discussion thread is based on that. Pls let me know if my understanding of using sqlite3_open16 is correct to store and retrieve utf16 strings. Thanks, Pavan. On 2

[sqlite] Sqlite for Embedded Devices

Hi, Could anyone share their observations/comments on having used sqlite as DB for embedded linux environment. Thanks, Pavan. -- ' Always finish stronger than you start *

[sqlite] sqlite c++ interfaces

Hi, I was googling for c++ interfaces for sqlite and found sqlitemm provides. But, i am unable to download the code. Can some one pls point me to link from where i can download the c++ interfaces for sqlite. Thanks, Pavan

Re: [sqlite] stupid man's manual to sqlite?

' Thanks, Pavan. On 3/8/07, Jakub Ladman <[EMAIL PROTECTED]> wrote: Hi (much smarter) friends. I need to start with sqlite (interfaced via C language) very quickly, unfortunately. I have not any experiences with any SQL, only some books. I am searching for some "stupid man's manual to

[sqlite] DB recovery

. Thanks, Pavan. -- ' Always finish stronger than you start *

Re: [sqlite] DB recovery

Hi Donald, Thanks, that was indeed a detailed explanation. The scenrio is an embedded device with sqlite in it and user does not have direct access to the DB. So, are there any Sqlite interfaces which do the recovery job mentioned in your email ? Thanks, Pavan. On 3/14/07, Griggs, Donald

[sqlite] multiple request handling

Hi, Does SQLite handle multiple request handling ? Thanks, Pavan. -- ' Always finish stronger than you start *

[sqlite] Fwd: Does SQLite provide XML support

-- Forwarded message -- From: pavan savoy <[EMAIL PROTECTED]> Date: Jan 31, 2006 7:17 PM Subject: Does SQLite provide XML support To: [EMAIL PROTECTED] Hi, I searched through your FAQ's mailing list, but the answer nor the question is not this simple. Hence

[sqlite] Fwd: Help regarding insertion into database

-- Forwarded message -- From: pavan savoy <[EMAIL PROTECTED]> Date: Feb 8, 2006 5:22 PM Subject: Help regarding insertion into database To: [EMAIL PROTECTED] Hi, Inside C program I have a structure and want to store it into a database, isnt there any datatype w

[sqlite] sqlite3_exec vs. sqlite3_prepare / sqlite3_step

Hi, sqlite3_exec is a wrapper function for sqlite3_prepare / step, but which one of these is faster, I mean in terms of execution. sqlite3_exec should still call a callback function and do all the string handling !! Also how do I use sqlite3_exec along with BLOB, I am

[sqlite] File format changed !!

I am trying to open a database created in SQLite 3.3.1 in SQlite 3.1.2 and I get the following err when I try to see the sqlite_master table .. SQL error: unsupported file format I suppose the file format has been changed over the versions, but the reverse does work, i.e db created on 3.1.2

[sqlite] Boolean casting

Dear all, I use in a view the following snip of code to force the results to be considered as Boolean: SELECT cast(start_processing_date is not null as BOOLEAN), ... I need this solution since in this way I can detect in java the Boolean data type by querying the ResultSet metadata