From: Sam Mason (sam@samason.me.uk)
Date: Fri Apr 17 2009 - 06:38:43 CDT
On Fri, Apr 17, 2009 at 11:02:16AM +0200, Philippe Verdy wrote:
> Also I see absolutely no "waste of space" when using them: the atabase will
> actually not use these syntaxes within the storage tables. The syntaxes are
> only for the occurrence of constant strings within SQL queries. They don't
> affect the data stored in input variables bound to SQL query placeholders,
> or in columns of SELECT result sets, except if they are converted and
> displayed this way by the SQL client itself.
As far as I understood the "waste of space" comment it was about about
what the database server does internally; it more applies to the code in
transit or when a literal of this form is stored outside the database in
source code.
I don't think this matters, after all "Programs should be written for
people to read, and only incidentally for machines to execute."
-- Sam http://samason.me.uk/
This archive was generated by hypermail 2.1.5 : Fri Apr 17 2009 - 06:40:18 CDT