Обсуждение: Temporarily disable strict UTF-8 checking

Поиск
Список
Период
Сортировка

Temporarily disable strict UTF-8 checking

От
"Matt Arnilo S. Baluyos (Mailing Lists)"
Дата:
Hello List,

After upgrading to 8.1 we've been having problems with input data
having invalid byte sequences.

There are some data that we need to input at the moment and it would
be helpful to *temporarily* disable this setting while our developers
try to sort out some filtering mechanism at the application level to
strip these invalid byte sequences.

Best regards,
Matt

--
Stand before it and there is no beginning.
Follow it and there is no end.
Stay with the ancient Tao,
Move with the present.

Re: Temporarily disable strict UTF-8 checking

От
Tom Lane
Дата:
"Matt Arnilo S. Baluyos (Mailing Lists)" <matt.baluyos.lists@gmail.com> writes:
> There are some data that we need to input at the moment and it would
> be helpful to *temporarily* disable this setting while our developers
> try to sort out some filtering mechanism at the application level to
> strip these invalid byte sequences.

You could set the database encoding to SQL_ASCII, if you want to
lobotomize the encoding-related functionality.

            regards, tom lane