Re: Error inserting RFC1738-encoded URLs - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: Error inserting RFC1738-encoded URLs
Date
Msg-id CABRT9RCHNEYEvXPGrhFLib=YmR-_Ypb=4eppYSJeiyVA3nZSFg@mail.gmail.com
Whole thread Raw
In response to Error inserting RFC1738-encoded URLs  (Javier Amor garcia <jamor@zentyal.com>)
List pgsql-general
On Mon, Oct 24, 2011 at 10:27, Javier Amor garcia <jamor@zentyal.com> wrote:
> sometimes I get encoding errors when inserting a s a encoded URL in a text
> field.

You forgot the most important thing: *What's* the error that you get?

>
http://www.formacion.aimplas.es/_Documentos/2011/FORMACIÓN%20ABIERTA/Folleto%20Especialistas%20Universitarios%20Polímeros%20ok.pdf

Since I have to guess, I suspect you're sending these strings to
Postgres in a non-UTF-8 encoding.

This isn't a valid URL anyway -- you can't have unquoted "Ó" or "í"
characters since they're not valid ASCII. But a 'varchar' field would
accept them anyway if you send them in the right encoding.

Regards,
Marti

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Adding a unique number to each record in a table
Next
From: Merlin Moncure
Date:
Subject: Re: Primary key Index Error