Re: [sqlite] encoding
Il giorno Thu, 24 Jun 2004 14:04:56 +0200, tu oh prode Michael Roth <[EMAIL PROTECTED]> hai scritto una mail. Il suo oggetto era"Re: [sqlite] encoding": > Looks like that's sqlitebrowser and phpsqliteadmin fault. Yes. it is as you said. As the matter of fact i made a perl script which make a SELECT and print the result set on my screen and accents are right. > Sqlite itself and the console tool 'sqlite' doesn't know anything > about utf-8 or encodings, because it doesn't matters to sqlite. Ok. Thanks i didn't know about it. > Maybee your tools are interpreting the bytes stored in the database as > iso8859-xx encodings. IIRC your results show that the two tools you > use are asuming iso8859-1 in the database, which if of course wrong. Thanks. Do you know how can i teach to my application (phpsqliteadmin and sqlitebrowser-GUI) the result set is utf8 and it is not iso8859-1? Thank all. -- ** The UNIX Guru's view of sex: unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep ** L'unica accelerazione possibile per windows: (9.81 m/s2) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] encoding
Hello i'm writing a program which insert a lot of strings in a sqlite db with perl language. Strings are in utf8 encoding. My system has utf8 locales too. I've a lot of problem with accents as èéàòù. I inserted them in a field. When i make a select of that field, i obtain right accents via shell: sqlite db.sqlite 'select frase from logchan limit 16660' => èéàòù On the contrary, if i look for that field via sqlitebrowser or phpsqliteadmin it result bad: ©Ã¹Ã Any suggestion? Thanks and sorry for my english :-( -- ** The UNIX Guru's view of sex: unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep ** L'unica accelerazione possibile per windows: (9.81 m/s2) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] palm pilot
Il giorno Wed, 2 Jun 2004 05:31:21 -0700 (PDT), tu oh prode Jalil Vaidya <[EMAIL PROTECTED]> hai scritto una mail. Il suo oggetto era"Re: [sqlite] palm pilot": > There is a PalmOS port of SQLite available. Mr. Wayne > on this list kindly sent me the code of his work on > the Palm port. I have not tested it on Palm Vx but I > do believe it works(Mr. Wayne can correct me if I am > wrong). I am working on Palm OS 6 port of SQLite but > haven't been able to get far as my dev machines either > keep crashing (for some totally different reasons) or > they get utilized for something else. When will I be > able to complete the port is an eternal question ;-) > Let me know if you need the code. I think it is a good idea to put the code and put a link in wiki as Puneet Kishor said. I have Palm OS 3.5 Do you think sqlite may work fine? Thanks -- ** The UNIX Guru's view of sex: unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep ** L'unica accelerazione possibile per windows: (9.81 m/s2) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] palm pilot
Hello, i hope not to ask a faq :-) I use a palm Vx. The biggest problem, in my opinion, i can't find a good databse for this device. I want to ask you if sqlite may run on palm. Is it possible? Is there a version for this device or is it planned? Thanks -- ** The UNIX Guru's view of sex: unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep ** L'unica accelerazione possibile per windows: (9.81 m/s2) pgp6JN1BuHTnv.pgp Description: PGP signature
[sqlite] palm pilot
Hello, i hope not to ask a faq :-) I use a palm Vx. The biggest problem, in my opinion, i can't find a good databse for this device. I want to ask you if sqlite may run on palm. Is it possible? Is there a version for this device or is it planned? Thanks -- ** The UNIX Guru's view of sex: unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep ** L'unica accelerazione possibile per windows: (9.81 m/s2) pgpdUp8a1W8Ga.pgp Description: PGP signature
Re: [sqlite] numrows
Il giorno Wed, 26 May 2004 09:20:24 -0400 (EDT), tu oh prode "H. Wade Minter" <[EMAIL PROTECTED]> hai scritto una mail. Il suo oggetto era"[sqlite] numrows": > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > [Apologies if this goes to the list twice - I had email issues last > night and couldn't tell if it went through] > > In DBD::SQLite, what's the proper way to get the number of rows > returned by a query? for example: > > $query = "SELECT * FROM foo WHERE bar LIKE '%baz%'"; > $sth = $dbh->prepare($query); > $sth->execute; I had a similar problem. I resolved in this way: $query = "SELECT Count(*),* FROM foo LIKE ''%baz%'"; > $sth = $dbh->prepare($query); > $sth->execute; You will have a single record in which first column is the number of record. Bye, nathanvi -- ** The UNIX Guru's view of sex: unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep ** L'unica accelerazione possibile per windows: (9.81 m/s2) pgp0ekGsyxusY.pgp Description: PGP signature
[sqlite] syncronizing
In my office we have to share a databse (a list of addresses). A lot of people has a notebook. So my idea was: - a file.sqlite on the server in which all people can add, delete, select contacts - when someone have to go away, he can copy this file on his notebook and modify it when he is outside office The problem is when he return in office because i would like the copy and the original in the server are syncronized... Is it possible? Is there an utility which does it? Thanks, nathanvi PS Sorry for my english :-( -- ** The UNIX Guru's view of sex: unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep ** L'unica accelerazione possibile per windows: (9.81 m/s2) pgpsfqSvx1dWN.pgp Description: PGP signature
[sqlite] phpsqliteadmin
Hello, it is the first time i write in this mailing list so i hope not to ask anything you spoke about. First of all sorry for my bad english :-) I started to use sqlite and i downloaded phpsqliteadmin. I put it in /var/www/phpsqlite but when i launch the browser and i write http://localhost/phpsqlite the URL became: http://localhost/phpsqlite/login.php?SessionID=3cc7a4fd920eed5648967467ae54f456 and the page is complete blank... Any suggestion? Is it a sqlite or apache problem? PS: in config/config.xml the authentication method is "sqlite" and auth.db is 766 for www-data.www-data PS: i use linux debian apache is up php4.3 is ok php4-sqlite is installed permission on /var/www/phpsqlite is 666 for www-data.www-data -- ** The UNIX Guru's view of sex: unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep ** L'unica accelerazione possibile per windows: (9.81 m/s2) pgp0.pgp Description: PGP signature