Re: weird - invalid string enlargement request size

Yes, encoding mismatch [:)]

"client_encoding";"UNICODE"
"lc_collate";"pt_BR.UTF-8"
"lc_ctype";"pt_BR.UTF-8"
"lc_messages";"pt_BR.UTF_8"
"lc_monetary";"pt_BR.UTF_8"
"lc_numeric";"pt_BR.UTF_8"
"lc_time";"pt_BR.UTF_8"
"server_encoding";"LATIN1"


I'm with some troubles to set the encoding In my PHP program, but this
is not hackers issue :)

I posted on hackers cause I think that was a bug, os something.

[]'s
- Walter

On Dec 4, 2007 3:46 PM, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> Walter Cruz escribió:
> > A simple query:
> >
> > select prec.bl_considerada_prioritaria
> > AS "A proposta é considerada prioritária por Conselho Municipal ou Estadual"
> > from consultaprevia2008.tab_urb_asse_prec prec
> >
> > The result: ERROR:  invalid string enlargement request size 1073741823
>
> Weird.  Probably encoding mismatch.  What are your locale and encoding
> settings, and what encoding is the actual client?  And what client is
> it?  Easiest way to show server settings is:
>
> select name, setting
> from pg_settings
> where name ~~ any ( array['lc_%', '%_encoding']);
>
> --
> Alvaro Herrera                        http://www.advogato.org/person/alvherre
> "La Primavera ha venido. Nadie sabe como ha sido" (A. Machado)
>