On Nov 6, 2007 8:55 AM, Joe Wilson [EMAIL PROTECTED] wrote:
It works in a Linux xterm.
There's probably some UTF or codepage issue with the Windows console.
Try using another command-line shell.
Thank you for your response Joe. It is a codepage issue. Using
sqlite3.exe 3.5.2 from a Windows XP
Hi,
is there any implications on performance of using collate i(NOCASE for
example) in the column definition when creating a table? doesn't it
effect the indexes use of those columns?
when using collate NOCASE on some column definition, how does a specific
element is chose to be returned, the
Hello,
in SQLite i can create a database user (in commnad line) ? What is the
sintax ?
Regards,
Paulito
Aviad Harell [EMAIL PROTECTED]
wrote:
is there any implications on performance of using collate i(NOCASE for
example) in the column definition when creating a table? doesn't it
effect the indexes use of those columns?
If you also create an index on this column, and don't explicitly specify
Om du inte protestera så skulle jag vilja hoppa över denna veckas
Torsdagsträff
För att lägga allt id på att få bokslutet klart.
Jag har pratat med Olle flera gånger, men glömt att be honom kolla på
burken.
Vilken adress var det den sitter på ?
/Bertil
-Ursprungligt meddelande-
Från:
I'm using version 3.5.2. I built the static library using MSVC++ 6. The
debug build works great. However, when I use the release build, the connect
works, but every SQL statement I try to execute returns SQL logic error or
missing database. I know it's not a configuration problem between the
Aviad Harell [EMAIL PROTECTED] wrote:
tnx for the quick replay.
when using collate NOCASE on some column definition, how does a
specific element is chose to be returned, the upper case, the lower
case or the first one appears?
Collation doesn't affect how the data is stored, just how
tnx for the quick replay.
when using collate NOCASE on some column definition, how does a
specific element is chose to be returned, the upper case, the lower
case or the first one appears?
Collation doesn't affect how the data is stored, just how it's compared.
You will get your strings out
Hi,
Greetings,
I followed one of the wiki notes on how a virtual table module method
such as xUpdate should set error message for consumption upstream. A
code snippet is:
...
sqlite3_free(aVTab-zErrMsg);
aVTab-zErrMsg = sqlite3_mprintf( No such FOO: %s, foo );
...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
paulito santana wrote:
Create a account in database for login ! Like you make in ORACLE, MySQL :
CREATE USER mike
There are no such things as users or logins in SQLite. It's an embedded
database. If you want to implement a permission
paulito santana
[EMAIL PROTECTED] wrote:
Create a account in database for login ! Like you make in ORACLE,
MySQL :
CREATE USER mike
SQLite doesn't provide access control, and doesn't have a notion of a
user or an account. So there's nothing to create.
Igor Tandetnik
Create a account in database for login ! Like you make in ORACLE, MySQL :
CREATE USER mike
2007/11/7, Igor Tandetnik [EMAIL PROTECTED]:
paulito santana
[EMAIL PROTECTED] wrote:
in SQLite i can create a database user (in commnad line) ? What is
the sintax ?
What exactly do you
Hi All,
about renaming table in sqlite (not sqlite3)
we can use this sql
'SELECT sql,name,type FROM sqlite_master WHERE tbl_name = 'table' ORDER BY
type DESC;'
to create a new table like the first one, and then use insert into new table
from select * from the previous one.
By this way we can keep
Thanks Andy
-Original Message-
From: Andrew McDermott [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 07, 2007 7:47 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How should virtual table module return
its own error messages?
Hi,
Greetings,
I followed one
paulito santana
[EMAIL PROTECTED] wrote:
in SQLite i can create a database user (in commnad line) ? What is
the sintax ?
What exactly do you mean by database user?
Igor Tandetnik
-
To unsubscribe, send email to
We have a database that can possibly grow into millions of rows. Some tables
have TEXT fields, which may store texts of signigicant length. All other data
is mostly numeric values.
We have a thought of moving all large texts into a separate table, and
replacing text_column with text_id in the
Igor Sereda [EMAIL PROTECTED] wrote:
We have a database that can possibly grow into millions of rows. Some =
tables have TEXT fields, which may store texts of signigicant length. =
All other data is mostly numeric values.
We have a thought of moving all large texts into a separate table,
[EMAIL PROTECTED] wrote:
Igor Sereda [EMAIL PROTECTED] wrote:
We have a database that can possibly grow into millions of rows. Some =
tables have TEXT fields, which may store texts of signigicant length. =
All other data is mostly numeric values.
We have a thought of moving all large
Thank you! How about separate DB just for large texts? Would that be an
overkill? We could use different page sizes for the two DBs. I'm not sure
how well transactions over several DBs are handled though.
Best regards,
Igor
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Igor Sereda [EMAIL PROTECTED] wrote:
Thank you! How about separate DB just for large texts? Would that be an
overkill? We could use different page sizes for the two DBs. I'm not sure
how well transactions over several DBs are handled though.
You could do that, but the benefits are dubious.
[Default] On Thu, 8 Nov 2007 00:50:47 +0300, Igor Sereda
[EMAIL PROTECTED] wrote:
Thank you! How about separate DB just for large texts?
Would that be an overkill?
I think it would be overkill indeed. I also think it's better to
have 'too large' pages for the 'numeric table' than to have too
21 matches
Mail list logo