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
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 |