Skip site navigation (1) Skip section navigation (2)

Re: text and bytea

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: hernan gonzalez <hgonzalez(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: text and bytea
Date: 2008-02-22 16:30:06
Message-ID: 20080222163006.GI9392@alvh.no-ip.org (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-general
Martijn van Oosterhout escribió:

> The most surprising this is that to_ascii won't accept a bytea. TBH the
> whole to_ascii function seems somewhat half-baked. If what you're
> trying to do is remove accents, there are perl functions around that do
> that. Basically, the switch to a different normal form then drop all
> the accent characters.

Yeah, it's been a common suggestion to use convert() in combination with
to_ascii on UTF-8 databases, and I didn't notice that the convert()
shuffling would take that ability away :-(  I don't think requiring
plperl is nice however.  Perhaps we could get around the problem by
using byteaout/textin.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

pgsql-general by date

Next:From: David JaquayDate: 2008-02-22 16:50:00
Subject: Re: Understanding ps -ef "command" column
Previous:From: Douglas McNaughtDate: 2008-02-22 16:28:34
Subject: Re: Understanding ps -ef "command" column

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group