Re: Client Encoding and Latin characters

Поиск
Список
Период
Сортировка
От Lee Hachadoorian
Тема Re: Client Encoding and Latin characters
Дата
Msg-id 5ab13580911240903q1a1ce069m5eecc9d05aac225b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Client Encoding and Latin characters  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> Uh, no.  You can pretty much assume that LATIN1 will take any random
> byte string; likewise for any other single-byte encoding.  UTF8 as a
> default is a bit safer because it's significantly more likely that it
> will be able to detect non-UTF8 input.
>
>                        regards, tom lane
>

So, IIUC, the general approach is:

*Leave the default client_encoding = server_encoding (in this case UTF8)
*Rely on the client to change client_encoding on a session basis only

Thanks,
--Lee

--
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center

В списке pgsql-general по дате отправления:

Предыдущее
От: Andrej
Дата:
Сообщение: Re: ora2pg and DBD::Pg
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: [HACKERS] Updating column on row update