7
7
7a-6662020-08-17 19:12:30
PostgreSQL
7a-666, 2020-08-17 19:12:30

Encoding error how to solve?

I have a file with sql commands there is a command that creates a type
CREATE TYPE name AS ENUM('Value 1', 'Value 2');
If you enter the command manually, then it will be executed; if you load the sql file with this command, it will be like this

ОШИБКА:  неверная метка в перечислении "отпуск Р·Р° СЃРІРѕР№ счёт"
ПОДРОБНОСТИ:  Длина метки не должна превышать 63 байт.

Encoding database utf8
I set this command to the beginning of the file
SET client_encoding TO 'utf8';
The error is gone but krakozyabry remained what can be done with them

Answer the question

In order to leave comments, you need to log in

1 answer(s)
F
freeExec, 2020-08-17
@7a-666

Set and console encoding to UTF8

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question