Hi,
Does Sqlite support unicode?
I have seen that it supports utf-8 and utf-16.
I want to know whether it supports unicode character formats.
Thanks and Best Regards,
A.Sreedhar.
Salutations,
I'm programing in C, new to SQLite, in Windows, with the Pelles C Compiler
for Windows.
When I create a Console project and put, for example, the following commands
(an SQLite connection with callback function):
static int callback(void *NotUsed, int argc, char **argv, char
SQLite Consortium Launches With Mozilla And
Symbian As Charter Members
Charlotte, North Carolina - December 12, 2007 - The SQLite
Consortium, a new membership association dedicated to maintaining
SQLite as a fully open and independent product, was formally
announced
Hi,
I am using the sqlite to store the metadata of audio files.
Is it possible to store the metadata in unicode character format in sqlite.
Best Regards,
A.Sreedhar.
-Original Message-
From: Trevor Talbot [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 4:40 PM
To:
On 12/12/07, CAVALO SCHMIDT <[EMAIL PROTECTED]> wrote:
> I'm programing in C, new to SQLite, in Windows, with the Pelles C Compiler
> for Windows.
> It works well. BUT, when I try to put this code in a Win32 application, like
> inside a WinMain procedure, for example, a strange behavior happens:
On 12/12/07, Sreedhar.a <[EMAIL PROTECTED]> wrote:
> Does Sqlite support unicode?
> I have seen that it supports utf-8 and utf-16.
> I want to know whether it supports unicode character formats.
Unicode is a very large and complex topic, so that question is way too
vague to answer. Can you
On 12/12/07, Sreedhar.a <[EMAIL PROTECTED]> wrote:
> I am using the sqlite to store the metadata of audio files.
> Is it possible to store the metadata in unicode character format in sqlite.
Yes; SQLite assumes all TEXT type data in the database is Unicode. You
can work with it in UTF-8 with the
hi C M,
I'm by no means an expert but what I do in similar cases is: I prepare
the variables beforehand - actually I prepare the whole SQL statement
beforehand and do normally not use ?. except by executemany.
date=date("now","+1 day")
sqlcu.execute ("SELECT string FROM test WHERE d
Very cool. Congratulations on getting this organized.
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Thankyou all for the quick replies.
Best Regards,
A.Sreedhar.
-Original Message-
From: Trevor Talbot [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 5:08 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unicode support for Sqlite?
On 12/12/07, Sreedhar.a <[EMAIL
utf-8 and utf-16 ARE unicode formats. But there are some things that
sqlite does not handle without the ICU extension.
The ICU extension extends SQLite with the following functionallity:
1.1 SQL Scalars upper() and lower()
1.2 Unicode Aware LIKE Operator
1.3 ICU Collation
On 12/11/07, Maxim V. Shiyanovsky <[EMAIL PROTECTED]> wrote:
> One more question - is there any way to insert utf-16 string from
> sqlite3.exe?
> As I understand I can't use syntax like this:
> insert into t values (X'31003700', 1);
No; the sqlite3 shell deals only in UTF-8, which is hard to
Thank you for the answer. Actually, I've already scattered MessageBox()
calls through the code, and I've found out exactly where the error happens.
For example, in a database where searching for text "key1" (column a)
returns "value1", "value2", "value3", and "value4" in column b, the callback
On 12/12/07, CAVALO SCHMIDT <[EMAIL PROTECTED]> wrote:
> For example, in a database where searching for text "key1" (column a)
> returns "value1", "value2", "value3", and "value4" in column b, the callback
> fnuction of that code would be called THREE times, returning thus three
> message boxes:
"Trevor Talbot" <[EMAIL PROTECTED]> wrote:
>
> > test.exe: WinMain( ) + 71
> > sqlite3.dll: sqlite3_exec( ) + 154
> > sqlite3.dll: sqlite3_column_text( ) + 1A
> > sqlite3.dll: sqlite3_data_count( ) + AC
> > ntdll.dll: RtlEnterCriticalSection( ) + B
>
> Hmm, looks like a fault within SQLite's
C M <[EMAIL PROTECTED]> wrote:
cur.execute('SELECT string FROM test WHERE d >= date("now","+1 day")')
However, I'd like to make it flexible, so that a user can put in an
amount of days forward or backward and the query will use
that--basically I want the user to be able to select the date range
It is SQLite 3.4.2, and I downloaded the ready binary, the DLL and sqlite3.h;
I didn't compile anything. But the sqlite3.lib didn't come ready; it came as
sqlite3.def together with the DLL, then I made it into a sqlite3.lib by
using the LIB.EXE utility of Visual Studio 6.0 -> LIB.EXE
On 12/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "Trevor Talbot" <[EMAIL PROTECTED]> wrote:
> > > test.exe: WinMain( ) + 71
> > > sqlite3.dll: sqlite3_exec( ) + 154
> > > sqlite3.dll: sqlite3_column_text( ) + 1A
> > > sqlite3.dll: sqlite3_data_count( ) + AC
> > > ntdll.dll:
Thank you for the response. So, how can I fix it? Can it have anything to do
with sqlite3.lib?
Is it a bug? Thank you in advance.
2007/12/12, Trevor Talbot <[EMAIL PROTECTED]>:
>
> On 12/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > "Trevor Talbot" <[EMAIL PROTECTED]> wrote:
>
> > > >
On 12/12/07, CAVALO SCHMIDT <[EMAIL PROTECTED]> wrote:
> It is SQLite 3.4.2, and I downloaded the ready binary, the DLL and sqlite3.h;
> I didn't compile anything. But the sqlite3.lib didn't come ready; it came as
> sqlite3.def together with the DLL, then I made it into a sqlite3.lib by
> using
How can I get a count of the number of records in a table?
Sqlite3_get_table() might work, but I only need the count, not the
record set.
Thanks,
Tom
I created a table with column 1 as primary key. So where are the index
records? I thought I would find them in the sqlite_stat1 table but
after inserting records in my table, there are no records in the
sqlite_stat1 table.
And, do primary keys need to be the first consecutive n fields? I
SELECT count(*) FROM myTable;
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Dec 12, 2007, at 2:55 PM, Tom Parke wrote:
How can I get a count of the number of records in a table?
Sqlite3_get_table() might work, but I only need the
Tom Parke <[EMAIL PROTECTED]> wrote:
I created a table with column 1 as primary key. So where are the
index records?
In the database, of course.
I thought I would find them in the sqlite_stat1 table
but after inserting records in my table, there are no records in the
sqlite_stat1 table.
Tom Parke <[EMAIL PROTECTED]> wrote:
How can I get a count of the number of records in a table?
select count(*) from tableName;
Igor Tandetnik
-
To unsubscribe, send email to [EMAIL PROTECTED]
It appears that Postgres, DB2 and SQL Server CE have issues with
certain types of alias expresssions in GROUP BY, while MySQL does
not.
Postgres will allow column aliases in GROUP BY - even aliases overriding
table column names - as long as every table column component of that
alias'
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2007-12-11 20:15]:
> But, as has been pointed out, you can work around it using
> a compile-time switch:
>
>gcc -DSQLITE_MAX_SQL_LENGTH=10 shell.c sqlite3.c -o sqlite3
>
> I should probably modify the makefile to do this
> automatically...
I received an email promoting a DeviceSQL web presentation. It
specifically targets Sqlite and promises 5X performance.
For those interested -
DeviceSQL vs. SQLite: Which Gets You the Most Efficient Embedded Database?
DATE: Thursday, December 13th, 2007
TIME: Noon
John Stanton <[EMAIL PROTECTED]> wrote:
> I received an email promoting a DeviceSQL web presentation. It
> specifically targets Sqlite and promises 5X performance.
>
If you view their web presentation and/or try out Encirq's
products, I would be very interested to hear your impressions.
Even
[EMAIL PROTECTED] wrote:
John Stanton <[EMAIL PROTECTED]> wrote:
I received an email promoting a DeviceSQL web presentation. It
specifically targets Sqlite and promises 5X performance.
If you view their web presentation and/or try out Encirq's
products, I would be very interested to hear
On Wed, 12 Dec 2007 11:28:40 +, [EMAIL PROTECTED] wrote:
> SQLite Consortium Launches With Mozilla And
> Symbian As Charter Members
>
Congratulations!
--
( Kees Nuyt
)
c[_]
-
To
Joe Wilson <[EMAIL PROTECTED]> wrote:
> Be careful about speculative comments.
>
> For all anyone knows, said product could use SQLite internally with
> a couple of proprietary optimizations here and there that may make it
> faster in specific cases.
>
> The sqlite public domain license would
Be careful about speculative comments.
For all anyone knows, said product could use SQLite internally with
a couple of proprietary optimizations here and there that may make it
faster in specific cases.
The sqlite public domain license would allow that sort of thing.
* John Stanton <[EMAIL PROTECTED]> [2007-12-12 17:55]:
> In general claims of "20x" or even "5x" imply either serious
> deficiencies in the compared product or a generous dose of
> snake oil in the challenger.
Depends. The outline given by Dr. Hipp about the product’s
features may the claim quite
Couldn't find anywhere how much this costs.
Newsgroup search shows nil.
Has anybody downloaded and tried the demo?
RBS
-Original Message-
From: Joe Wilson [mailto:[EMAIL PROTECTED]
Sent: 12 December 2007 17:10
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] DeviceSQL
Be careful about
Hi,
Am Mittwoch, 12. Dezember 2007 schrieb CAVALO SCHMIDT:
> Ok, I'm sending to you a zip file with the Pelles C project, together
> with the database (a small test database, with a key1 with 2 values
> [which doesn't throw errors] and a key2 with six values [which throws the
> error]); note that,
I'm running SQLite 3.4.1 under Linux. I have a C++ application that
inserts records into the database.
During testing, I lauch the C++ app and I start sqlite3 from a console
and open the database that is being written to by the C++ application.
I perform selects using sqlite3 (no inserts) to
On Dec 12, 2007 8:20 AM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> C M <[EMAIL PROTECTED]> wrote:
> > cur.execute('SELECT string FROM test WHERE d >= date("now","+1 day")')
> >
> > However, I'd like to make it flexible, so that a user can put in an
> > amount of days forward or backward and the
C M wrote:
Thanks to you both--using the || did the trick, and I can try the other
approaches mentioned as well. In Python Igor's suggestion was just:
amount = "+1"
cur.execute('SELECT string, d FROM test WHERE d >= date("now", ? || ? || "
days")',amount)
You will might be better off
Thank you, it worked.
2007/12/12, Uwe Sander <[EMAIL PROTECTED]>:
>
> Hi,
> Am Mittwoch, 12. Dezember 2007 schrieb CAVALO SCHMIDT:
> > Ok, I'm sending to you a zip file with the Pelles C project, together
> > with the database (a small test database, with a key1 with 2 values
> > [which doesn't
Your application needs to handle the synchronization logic since there
is no DB server to do it for you. When you get a busy check you can
pause for a short time and relaunch the query.
Mark Riehl wrote:
I'm running SQLite 3.4.1 under Linux. I have a C++ application that
inserts records
John Stanton wrote:
Your application needs to handle the synchronization logic since there
is no DB server to do it for you. When you get a busy check you can
pause for a short time and relaunch the query.
Mark Riehl wrote:
I'm running SQLite 3.4.1 under Linux. I have a C++ application
[EMAIL PROTECTED] wrote:
SQLite Consortium Launches With Mozilla And
Symbian As Charter Members
...
Additional information is available at the SQLite website,
http://www.sqlite.org/.
Congratulations!
You might want to fix one small typo I noticed:
"The SQLite
On Dec 12, 2007 1:51 PM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> C M wrote:
> >
> > Thanks to you both--using the || did the trick, and I can try the other
> > approaches mentioned as well. In Python Igor's suggestion was just:
> >
> > amount = "+1"
> > cur.execute('SELECT string, d FROM test
Mark Riehl wrote:
Am I just getting [un]lucky and issuing selects at the same time I'm
writing from the other process?
Yes.
I'm planning on using a web-based app
to periodically poll the database (to provide summary information)
while the C++ app performs the inserts. What is the best way
Hi,
Sorry if this has been asked previously. I searched the archives and
couldn't find anything.
Is there perhaps an RSS feed version of new releases of SQLITE? I'm not
talking about the detailed feed about every little bug that has been
fixed. I'm basically looking for an RSS version of
Hi All,
This is the exaclty approach that I used in my code.
No way to reduce/minimize the lock issue regardless about the reading or the
writting.
We need to have to code to sleep and re-try the command again.
JP
- Original Message
From: Richard Klein <[EMAIL PROTECTED]>
To:
Hello,
There seems to be a high interest in columnar databases recently.
Is there any plan of supporting data organization as a columnar database in
SQLite? What are the challenges here?
Regards,
Yuva
Hi All,
I have been working on MSSQL server and SQLite is new to me. I usually did the
following in MSQL server to check of the specific row is existed in the table
and have different action depending on the result of the check. For example:
Create table versionTable (dbVersion varchar(20)
Joanne Pham wrote:
I have been working on MSSQL server and SQLite is new to me. I
usually did the following in MSQL server to check of the specific row
is existed in the table and have different action depending on the
result of the check. For example: Create table versionTable
(dbVersion
Hi Igor,
Thanks for the response.
Basiclly there is no SQL logic in SQLite.
I would like to check if the database version is xyz then I will have different
action and if then database version is abc then I will have different action.
So SQLite doesn't allow this luxury.
Thanks,
JP
-
Hi Joanne,
I have been working on MSSQL server and SQLite is new to me. I
usually did the following in MSQL server to check of the specific
row is existed in the table and have different action depending on
the result of the check. For example:
Create table versionTable (dbVersion
This is Steve Weick, CTO & VP Engineering at Encirq Corp., developers and IP
owners of DeviceSQL. I would like to address D. Richard Hipp’s statements.
RDH:"If you view their web presentation and/or try out Encirq's products, I
would be very interested to hear your impressions. Even better would
At 4:42 AM +0530 12/13/07, Yuvaraj Athur Raghuvir wrote:
Hello,
There seems to be a high interest in columnar databases recently.
Is there any plan of supporting data organization as a columnar database in
SQLite? What are the challenges here?
Regards,
Yuva
Something I will say about this, for
>SW: Richard, We have written to you directly before to ask you to stop the
>FUD and incorrect statements, and you have chosen to continue. I suggest you
>not waste everyone's time by circulating deliberately misleading
>information.
I think you are very aggressive and I think you must apologise
55 matches
Mail list logo
