Re: [sqlite] found a Malware , when download sqlite-shell-win32-x86-3071500.zip

[Roy Tam]

Hello,

2012/12/18 Miles Liu :
> sqlite-shell-win32-x86-3071500
> when download it , anti-virus said found a Malware.

False positive. VirusTotal report here:
https://www.virustotal.com/file/85fa29a391d7ab8af4736dfd36222a651a9b3af56c5f81bb58c9b106eaa63533/analysis/1355816443/

HTH,
Roy
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite-users Digest, Vol 52, Issue 1

[Roy Tam]

2012/4/2 YAN HONG YE :
> when I run this following code  , the html file encoding changed to 
> GB2312,not utf-8, I don't know why?
> system("echo ^ >mm.html");
>   system("sqlite3 -html -header foods.db \"select * from dzh where 
> qph15>10;\" >>mm.html");
>   system("echo ^ >>mm.html");

You're windows user, right?
system() in windows will convert all things to System Codepage
(CP_ACP), so please use C bindings and write output in C but not using
system().

> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

[Roy Tam]

2010/3/29 P Kishor :
> On Sun, Mar 28, 2010 at 10:50 PM, Dan Kennedy  wrote:
>>
>> On Mar 29, 2010, at 10:48 AM, P Kishor wrote:
>>
>>> On Sun, Mar 28, 2010 at 10:45 PM, Roger Binns
>>>  wrote:
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 sub sk79 wrote:
> How So? Is SQLite getting a high concurrency module from BDB in
> exchange for its SQL API?

 I believe the btree/paging layer is replaced with BDB.

>>>
>>>
>>> How does BDB's (or any code from Oracle) inclusion into the SQLite
>>> source tree affect the public domain nature of SQLite? To the extent
>>> that there is any code from Oracle, has that been dedicated to public
>>> domain as well? Am very curious about clarity on this.
>>>
>>> Also, from which version on has Oracle code entered the SQLite tree?
>>
>> No Oracle code has been added to the SQLite tree. SQLite licensing
>> remains unchanged.
>>
>
>
> thanks for the clarification, but how does the above statement
> reconcile with "the btree/paging layer is replaced with BDB"? Does
> that refer to a different version of SQLite being offered by Oracle
> that includes BDB for storage? I hope that will be called something
> else... mebbe sqlbdb?
>

Oracle will release their own version SQLite using BDB as backend called BDBSQL.
Source (Developer blog in Chinese):
http://www.bdbchina.com/2010/03/oracle-berkeley-db-%e6%94%af%e6%8c%81sql%e5%95%a6%ef%bc%81/#more-862

>
>
> --
> Puneet Kishor http://www.punkish.org
> Carbon Model http://carbonmodel.org
> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
> Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
> Nelson Institute, UW-Madison http://www.nelson.wisc.edu
> ---
> Assertions are politics; backing up assertions with evidence is science
> ===
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

[Roy Tam]

2010/3/29 Roger Binns :
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> sub sk79 wrote:
>> How So? Is SQLite getting a high concurrency module from BDB in
>> exchange for its SQL API?
>
> I believe the btree/paging layer is replaced with BDB.
>

Confirmed.
http://twitter.com/gregburd/statuses/10979336891

> Roger
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.9 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iEYEARECAAYFAkuwImUACgkQmOOfHg372QT27wCgmiuebBj/sHSDiI6CyemBquW9
> D5AAn0/rBQf2SkYQmJTcJrRsizfNt08S
> =Mocr
> -END PGP SIGNATURE-
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 16 bits

[Roy Tam]

2010/3/25 Simon Slavin :
>
> On 25 Mar 2010, at 2:04am, Andi Suhandi wrote:
>
>> Is there SQLite for 16 bit OS ?
>> I want to use sqlite in my program in turbo c++ and running in DOS.
>
> You can download SQLite as source code, and use whatever C compiler you're 
> using for your own software to compile it.  What you probably want is the 
> first download link on this page:
>
> http://www.sqlite.org/download.html
>
> There is no reason that the source code supplied should not compile properly 
> on a 16 bit OS.  However, you may need to make minor changes to some of the 
> compiler directives if Turbo C++ makes assumptions about word lengths, etc..
>

It was heard that SQLite 3.x was ported to DJGPP and Borland C++.
http://groups.google.com/group/comp.os.msdos.djgpp/browse_thread/thread/5f40742a2df9844b
http://fixunix.com/ms-dos/21520-sqlite-3-0-7-ported-djgpp.html
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fw: Problem in version 3.3.10

[Roy Tam]

Try recompiling with Intel C++ Compiler.

2007/1/19, A.J.Millan <[EMAIL PROTECTED]>:



 Hi:

 An application was running Ok under version 3.3.7.  When recompiling with
v.
 3.3.10, crashed at certain point in runtime.  "invalid page in module
 MSVCRT.DLL of 0167:780027a3".

 The Sistem is running MS Windows98 SE fully patched.

 Msvcrt.dll is version 6.10.8924.0.

I compile with GNU G++ 3.4.2-20040916-1 for Windows (Dev-C++).

Is there some known bug?

Some way to compile without the Msvcrt.dll dependency?

 I'd be grateful for any help.

 A. J. Millan



-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] utf8 decode

[Roy Tam]

Hi,

I think you should provide sample data in order to dig out the problem.

Regards,

2006/9/20, 卢炎君 <[EMAIL PROTECTED]>:

Hi guys
   First of all, all data be complied as UTF-8 stored in my DB.
   Second, When   I used sqlite browser tool (from sourceforge)to browsed my 
DB, the result of chinese characters are correct, then I write a function which 
just call sqlite3_column_text inside it, Demo like below:
const char* demo(..)
{
 ...
return (const char*)sqlite3_column_text(mpVM, nField);
 ...
}
BTW, all something on the same DB and same recorde. I found that the same 
result of chinese characters are incorrect,