On 09/06/2013 09:14 AM, Craig Ringer wrote:
> On 09/05/2013 08:47 PM, Peter Eisentraut wrote:
>> Other ideas? Are there legitimate uses for SQL_ASCII?
>
> IMO people who want SQL_ASCII should actually be storing everything in
> `bytea`; that's a truer reflection of what they're actually storing,
> retrieving, and working with and how they're doing it.
Practically speaking, the escaping gets in the way, and there isn't full
feature parity with TEXT. Regular expression matching seems to be
missing, for instance.
But apart from that, yes, BYTEA would be the more appropriate choice.
--
Florian Weimer / Red Hat Product Security Team