Re: Handling of Surrogates

From: Sam Mason (
Date: Fri Apr 17 2009 - 06:38:43 CDT

  • Next message: Sam Mason: "Re: Handling of Surrogates"

    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."


    This archive was generated by hypermail 2.1.5 : Fri Apr 17 2009 - 06:40:18 CDT