pgAgent and encoding

From: pasman pasmański <pasman(dot)p(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pgAgent and encoding
Date: 2011-10-27 12:54:18
Message-ID: CAOWY8=a+Dj6Qsu7C_bwnxDQxnjviOcVv7LNGZWowzcvbr78tCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I can't set proper encoding for pgAgent.
I have two databases: postgres and www.
postgres is encoded in UTF8, www is encoded in WIN1250.

When i run pgAgent's task in www database, it fail (message char cant
be converted to UTF8):

2011-10-27 14:50:29 CEST [nieznany] 1.COPY
BŁĄD: kolumna "KodB³êdu" nie istnieje przy znaku 80
2011-10-27 14:50:29 CEST [nieznany] 2.COPY
WYRAŻENIE: COPY (

SELECT

to_char("DataPliku",'YYYYMM') AS "MiesiÂąc zwrotĂłw",

"KodB³êdu","NKA","NTA",

sum(case when "NRB" like '070%' then null else 1 end) as "CDR",

sum(case when "NRB" like '070%' then 1 end) as "CDR_070",

array_agg(distinct case when "NRB" like '070%' then null else "ID
Kobat" end) AS "RecNR",

array_agg(distinct case when "NRB" like '070%' then "ID Kobat" end)
AS "RecNR_070"

FROM "Bladpol2"

WHERE "KodB³êdu" = '61' AND to_char("DataPliku",'YYYYMM') like
'${MONTH_1}'

GROUP BY to_char("DataPliku",'YYYYMM'), "KodB³êdu", "NKA", "NTA"

ORDER BY "NKA", "NTA", Min("DataPliku")

)

TO 'e:\raport_61.csv' CSV HEADER DELIMITER ';'


2011-10-27 14:50:29 CEST [nieznany] 1.idle
BĹ Ä"D: znak 0x83 kodowania "WIN1250" nie ma rĂłwnowaĹĽnego w "UTF8"

How to set the correct encoding ?

------------
pasman

Browse pgsql-general by date

  From Date Subject
Next Message Ing.Edmundo.Robles.Lopez 2011-10-27 13:22:58 How are PGRES_FATAL_ERROR raised?????
Previous Message David Johnston 2011-10-27 12:35:30 Re: Saving score of 3 players into a table