Thanks all. My requirement was for SQL and unfortunately just the one query.
It is also not actually required to get a row count for all tables -
that just serves as a good example of my requirement, which is using a
table name as a variable.
There are plenty of ways around this, but I didn't
On 2014/11/17 14:48, RP McMurphy wrote:
PS: Some administravia; Does anyone know of a way to reduce the posting delay for this list? Is it always like this? Or is it some
problem with the gmane site in general?
Join the mailing list directly (you can unsubscribe once you got what you were
On 2014/11/17 14:48, RP McMurphy wrote:
Upon further analysis it appears that the data shape is different in different periods within the table. That is, some sections
have the inverse shape to other sections. So it looked like query times would change over time but actually they are changing
On 18 Nov 2014, at 8:46am, Paul Sanderson sandersonforens...@gmail.com wrote:
my requirement, which is using a
table name as a variable
This is deliberately made very difficult in SQL. I think it's for security
reasons.
Simon.
___
sqlite-users
Hi,
I am using SQLite version 3.8.7.1
I am not able to insert Hindi Language into table. So please help me
regarding this.
May you send me the table structure and insert query for inserting Hindi
text into table.
Thanks Regards
Arvind
___
CREATE TABLE example(x TEXT);
INSERT INTO example(x) VALUES('हैलो, विश्व');
SELECT * FROM example;
On Tue, Nov 18, 2014 at 5:42 AM, ARVIND KUMAR arv...@sblsoftware.com
wrote:
Hi,
I am using SQLite version 3.8.7.1
I am not able to insert Hindi Language into table. So please help me
See also http://www.sqlite.org/pragma.html#pragma_encoding
John
On Tue, Nov 18, 2014 at 4:42 AM, ARVIND KUMAR arv...@sblsoftware.com
wrote:
Hi,
I am using SQLite version 3.8.7.1
I am not able to insert Hindi Language into table. So please help me
regarding this.
May you send me the table
On 2014/11/18 15:12, Richard Hipp wrote:
CREATE TABLE example(x TEXT);
INSERT INTO example(x) VALUES('हैलो, विश्व');
SELECT * FROM example;
The point being that Hindi isn't special, the presented characters are Unicode just like all the others - as long as your DB text
encoding is set to
It would have just been a nice elegant solution to a minor problem.
Lots of other ways of skinning this cat.
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic