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