SQLite semi Embedded database functionality in AutoIt

[oren]

Hello

Thank you for this wonderful udf Its really useful

I dont really know sql and I need to build a database in a language other then english (hebrew) ,

But when I try to INSERT new values in the database I get

!   SQLite.au3 Error
--> Function: _SQLite_Exec

Anything that I can do? , Anyway to make it work with other languages other then English?

Thanks.

[ptrex]

@Oren

I am not sure SQLite supports UNICODE.

But a quick search on the net give you this workaround

UNICODE workaround

[EDIT]

SQLite does support UNICODE but you need to set the paramaters correct before creating the DB.

More info here :

PRAGMA encoding;

PRAGMA encoding = "UTF-8";

PRAGMA encoding = "UTF-16";

PRAGMA encoding = "UTF-16le";

PRAGMA encoding = "UTF-16be";

In first form, if the main database has already been created, then this pragma returns the text encoding used by the main database, one of "UTF-8", "UTF-16le" (little-endian UTF-16 encoding) or "UTF-16be" (big-endian UTF-16 encoding). If the main database has not already been created, then the value returned is the text encoding that will be used to create the main database, if it is created by this session.

The second and subsequent forms of this pragma are only useful if the main database has not already been created. In this case the pragma sets the encoding that the main database will be created with if it is created by this session. The string "UTF-16" is interpreted as "UTF-16 encoding using native machine byte-ordering". If the second and subsequent forms are used after the database file has already been created, they have no effect and are silently ignored.

Once an encoding has been set for a database, it cannot be changed.

Databases created by the ATTACH command always use the same encoding as the main database.

Regards,

ptrex

Edited March 26, 2009 by ptrex

[oren]

@ptrex

Thanks for the replay..

But sqlite can indeed store hebrew strings..

It was my fault wen i did GUICtrlRead ($ID) , I forgat to pur

' '

around it..

Sorry.

[oren]

Well Now I really do have a problem the _SQLite_Open command does not allow me to open a database with a directory in language other then english (I'm trying from a hebrew directory..)

#include <GUIConstantsEx.au3>
#include <EditConstants.au3>
#include <sqlite.au3>
#include <sqlite.dll.au3>
#include <Date.au3>
#include <array.au3>
_SQLite_Startup()
ConsoleWrite(@scriptdir & @crlf )
_SQLite_Open(@scriptdir &"\Database.db")
Exit

the consolewrite command sow me

C:\שמור\parkproject
!   SQLite.au3 Error
--> Function: _SQLite_Open
--> Error:  Library used incorrectly

Anyway to fix this problem?

[jchd]

Well Now I really do have a problem the _SQLite_Open command does not allow me to open a database with a directory in language other then english (I'm trying from a hebrew directory..)

#include <GUIConstantsEx.au3>
#include <EditConstants.au3>
#include <sqlite.au3>
#include <sqlite.dll.au3>
#include <Date.au3>
#include <array.au3>
_SQLite_Startup()
ConsoleWrite(@scriptdir & @crlf )
_SQLite_Open(@scriptdir &"\Database.db")
Exit

the consolewrite command sow me

C:\שמור\parkproject
!   SQLite.au3 Error
--> Function: _SQLite_Open
--> Error:  Library used incorrectly

Anyway to fix this problem?

Hi,

A complete solution for full Unicode support with SQLite (and Console) is well underway. A little patience will be soon rewarded.

[frankiben123]

wow thank you guys....

sales tracking software

Edited June 25, 2009 by frankiben123

[Zedna]

Thanks for SQLite UDF. I used it in several my projects and it's awesome!

I have found very nice and free manager for SQLite databases - it's free also with sources

Sqliteman - Sqlite Databases Made Easy

http://sqliteman.com/

EDIT: screenshot

http://sqliteman.com/data/phoo/2007_08_26/sqliteman2.png

Edited June 25, 2009 by Zedna

[Yoriz]

If your a firefox user theres a nice little sql addon that i use

SQLite Manager Add on for Firefox

[ptrex]

@all

My two cents :

SqliteAdmin

My Favorite :

SqliteExplorer

Including a report generator & script engine:

Enjoy !!

Regards,

ptrex

[Zebulon]

Hello Folks,

my favorite SQLite manager:

SQLite2009 Pro Enterprise Manager (freeware)

http://osenxpsuite.net -> download

Greetings

Zebulon

[ptrex]

@Zebulon,

Great finding !

Thanks for sharing.

Rgds,

ptrex

[Zedna]

@ptrex

You may add all these links to SQLite tools/managers to your first post.

It would be cool to have them all at one place.

[jchd]

Also give a try to another excellent tool (Windoze only) :

SQLite Expert

You can download a free version which offers almost every option the payware Pro version has. Both versions are loaded with useful [and usable] features.

The author is very friendly and responsive.

[ptrex]

@Zedna

This is a good idea to move them all to the first post.

But since the new forum upgrade, I can't add hyperlinks in posts anymore.

The input box jumps out of reach beyond the screen limits.

Regards

ptrex

[Zedna]

But since the new forum upgrade, I can't add hyperlinks in posts anymore.

The input box jumps out of reach beyond the screen limits.

Try to use another web browser: IE/Firefox/Opera/Chrome/...

I used alternative browser too on old forum when I needed edit posts with more Autoit tags for example.

[ptrex]

@Zedna

Sorry for the late reply.

But I was sitting on a Greec Island for a while. >_<

I have already tested 2 different Browsers IE6 and Avant Browser.

No success.

Regards,

ptrex

[ValeryVal]

If your a firefox user theres a nice little sql addon that i use
SQLite Manager Add on for Firefox

It was used here, too. See here, please.

AFireFox_Full can do this fine.

There is just one task - The SQLite+WEB.Au3+FireFox trick to open SQLite Manager on server-side.

[oriolgs58]

Hi,

Where can I download the latest UDF/examples/...?

I did grab the zip file with the dll stuff but on the first post if I click on downlaods it just brings me to the index page..

Thx

[Zedna]

Hi,

Where can I download the latest UDF/examples/...?

I did grab the zip file with the dll stuff but on the first post if I click on downlaods it just brings me to the index page..

Thx

This UDF is now part of standard Autoit's UDFs

C:\Program Files\AutoIt3\Include\SQLite.au3

Functions/examples are in Autoit's helpfile.

[oriolgs58]

Oh nice i hadn't realized we were talkinga bout the same UDF. Anway do we still need to register a bunch of dlls if we want to distribute this with our code?