Re: Error inserting RFC1738-encoded URLs

Поиск
Список
Период
Сортировка
От Marti Raudsepp
Тема Re: Error inserting RFC1738-encoded URLs
Дата
Msg-id CABRT9RCHNEYEvXPGrhFLib=YmR-_Ypb=4eppYSJeiyVA3nZSFg@mail.gmail.com
обсуждение исходный текст
Ответ на Error inserting RFC1738-encoded URLs  (Javier Amor garcia <jamor@zentyal.com>)
Список 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 по дате отправления:

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: Adding a unique number to each record in a table
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Primary key Index Error