Martijn van Oosterhout wrote:
> On Wed, Jul 19, 2006 at 05:24:53PM -0400, Eric Faulhaber wrote:
>> OK, but now that this "feature" has been removed in 8.1.4, how is this
>> supposed to be handled, given that we don't control what string data
>> we're handed? How does psql deal with it?
>
> Well, bytea handles null like it always has. There must be a way to you
> to store strings into bytea columns... But I only have a vague
> understanding of why bytea won't work for you...
Collation, for one. Our runtime is extremely sensitive to the order in
which records are read, to the point where I've created a custom locale
just for the PostgreSQL cluster.
Then there's case sensitivity, being able to use string functions in
SQL, etc., etc. Bottom line, these are valid strings, so we need to
treat them as such.
Thanks,
Eric