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 <[EMAIL PROTECTED]> 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) > ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
