The following bug has been logged online: Bug reference: 1438 Logged by: Estagus Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: Debian SID Description: Non UTF-8 client encoding problem Details:
Hi... I use postgresql 7.4.6 on Debian woody SID/unstable. I set client encoding to koi8 in file postgresql.conf I connect to base using psql shell. See shell commands: # \encoding KOI8 # \d bla bla bla all ok # CREATE TABLE onoff(id BIGSERIAL UNIQUE NOT NULL, user_id BIGINT NOT NULL, made_id BIGINT NOT NULL, progress BOOL NOT NULL, is_on BOOL NOT NULL, tarif_id INTEGER NOT NULL, date_ins DATE NOT NULL, date_todo DATE NOT NULL); ERROR: ignoring unconvertible UTF-8 character 0xd3cf # set client_encoding to utf8; SET # CREATE TABLE onoff(id BIGSERIAL UNIQUE NOT NULL, user_id BIGINT NOT NULL, made_id BIGINT NOT NULL, progress BOOL NOT NULL, is_on BOOL NOT NULL, tarif_id INTEGER NOT NULL, date_ins DATE NOT NULL, date_todo DATE NOT NULL); bla bla bla all ok... # \d ERROR in russian... # set client_encoding to koi8; SET # \d all ok... If i missed some info, please tell me... ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
