| From: | Marti Raudsepp <marti(at)juffo(dot)org> |
|---|---|
| To: | Javier Amor garcia <jamor(at)zentyal(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Error inserting RFC1738-encoded URLs |
| Date: | 2011-10-24 11:37:38 |
| Message-ID: | CABRT9RCHNEYEvXPGrhFLib=YmR-_Ypb=4eppYSJeiyVA3nZSFg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Oct 24, 2011 at 10:27, Javier Amor garcia <jamor(at)zentyal(dot)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?
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2011-10-24 12:08:14 | Re: Autentication exceptions in pgsql 8.3 |
| Previous Message | Edoardo Panfili | 2011-10-24 11:18:04 | Re: PostGIS in a commercial project |