Re: 8.0.0beta4: "copy" and "client_encoding"
От | mbch67@yahoo.com |
---|---|
Тема | Re: 8.0.0beta4: "copy" and "client_encoding" |
Дата | |
Msg-id | fe065ce.0411050019.464d6929@posting.google.com обсуждение исходный текст |
Ответ на | 8.0.0beta4: "copy" and "client_encoding" (mbch67@yahoo.com) |
Ответы |
Re: 8.0.0beta4: "copy" and "client_encoding"
|
Список | pgsql-jdbc |
> I suppose that in the absence of backend support for this, we could add > some URL parameter that allows client_encoding to be changed, with > suitably dangerous warnings around using it. Then you can temporarily > flip client_encoding to LATIN1 for the duration of the COPY, and revert > it to UNICODE afterwards. > To me a temporarly fix is not really the solution. Shouldn't there be done some more investigations first, e.g. 1. I set LATIN1 as the database (postgresql.conf) default client encoding. Why does COPY, executed via JDBC not use the right encoding? => To me it seems to be a backend problem. Should this be address in another posting list? 2. Was the decision to disable the "SET CLIENT_ENCODING" command really a good idea? What about if I am running a server using UNICODE to store text, my default client encoding is LATIN1 and I want to import a Korean encoded text file using COPY via JDBC? There is no way to tell COPY what encoding the input file based on. In order to be compliant with PSQL I suggest to reactivate the disabled "SET CLIENT ENCODING" for JDBC.
В списке pgsql-jdbc по дате отправления: