On Mon, Oct 24, 2011 at 10:27, Javier Amor garcia <jamor@xxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general