On Wed, 9 Jan 2008 14:33:40 +0100, Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
>On Wed, Jan 09, 2008 at 12:51:16PM +0000, [EMAIL PROTECTED] wrote: > >> > Why not have a possibility to make it default >> > behaviour of the SQL-engine itself, just by >> > using one "pragma"? >> > >> > 1. It'll make my code shorter. >> >> But it makes the SQLite core code larger. Why should the the >> SQLite core be enlarged for the convenience of a single user. > >It's rather hard to say, if really just "single". >SQLite, as I understood, has many users; just three >of them were "against", until this time. Most people are not really "me2" type of persons, so they don't speak out. But if you insist: although it seems a nice to have feature, I'm against an auto_trim PRAGMA. In my opinion drh's reasoning is valid. I, for example, would be able to come up with several features comparable to the one you propose, such as auto_uppercase, auto_lowercase, or auto_fill_asterisk (for lawyers), you name it. As the source of SQLite is in the public domain it won't be too difficult to build your own sqlite3_bind_trimmedtext(). I usually delegate the data-validation and -massaging to the application level. -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
