Re: [sqlite] "always-trim" - feature suggestion

At 3:28 AM +0100 1/7/08, Zbigniew Baniewski wrote: I think, that it sometimes could be useful as secondary protection: a feature (perhaps another "pragma"?), which will cause stripping the spaces from beginning and end of every inserted string. But perhaps even not just only as "secondary"?

[sqlite] "always-trim" - feature suggestion

I think, that it sometimes could be useful as secondary protection: a feature (perhaps another "pragma"?), which will cause stripping the spaces from beginning and end of every inserted string. But perhaps even not just only as "secondary"? Yes, usually it's done at application level; I was

RE: [sqlite] Date Problems

> Can somebody give any explain to this please. > sqlite> select date("2006-03-31"); > 2006-03-31 > --> correct > > sqlite> select date("2006-03-31", "-1 month"); > 2006-03-03 > --> not correct > > > Can anyone confirm? Any suggestions / workarounds greatfully > received! I've seen other

[sqlite] How to compile SQLite with SQLITE_ENABLE_COLUMN_METADATA option under Ubuntu Linux

Hi, I'm writting a component set to wrap sqlite database with FPC (Free Pascal Compiler) / Lazarus and Delphi available at http://source.online.free.fr To enable Queries data editing, I need to use the library compiled with SQLITE_ENABLE_COLUMN_METADATA option. After many tries, I succeed

[sqlite] ANN: SQLite ODBC driver version 0.77 released

Dear all, version 0.77 of the SQLite ODBC driver is available for download from http://www.ch-werner.de/sqliteodbc It's Windows one-click installer is built with SQLite 3.5.4 and 2.8.17. There were two major bug fixes with respect to wide-char parameter binding and wide-char data retrieval,