Thread: BUG #6135: I wander in the backup of the bank, Portuguese generation of characters, atmosphere windows xp, post
BUG #6135: I wander in the backup of the bank, Portuguese generation of characters, atmosphere windows xp, post
From
"andre luiz"
Date:
The following bug has been logged online: Bug reference: 6135 Logged by: andre luiz Email address: andreluiz1111@gmail.com PostgreSQL version: 9.0.4 Operating system: windows xp Description: I wander in the backup of the bank, Portuguese generation of characters, atmosphere windows xp, post Details: I wander in the backup of the bank, Portuguese generation of characters, atmosphere windows xp, postgresql enconding utf-8. It is not generating the characters correctly in Portuguese (accentuation, cedilla - example: õ, ç) 1. Generation of the table: CREATE TABLE area ( id_area serial NOT NULL, codigo smallint NOT NULL, nome character varying(40) ); ALTER TABLE ONLY area ADD CONSTRAINT pk_area PRIMARY KEY (id_area); INSERT INTO area (id_area, codigo, nome) VALUES (1, 1, 'Almoço'); INSERT INTO area (id_area, codigo, nome) VALUES (2, 2, 'Refeição'); INSERT INTO area (id_area, codigo, nome) VALUES (3, 3, 'Cardápio'); 2: The Backup of the bank presents mistakes in the command insert - loss of the characters in Portuguese: -- -- PostgreSQL database dump -- -- Dumped from database version 9.0.4 -- Dumped by pg_dump version 9.0.4 -- Started on 2011-07-30 22:55:45 SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; -- -- TOC entry 1785 (class 1262 OID 16432) -- Name: teste01; Type: DATABASE; Schema: -; Owner: postgres -- CREATE DATABASE teste01 WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'Portuguese, Brazil' LC_CTYPE = 'Portuguese, Brazil'; ALTER DATABASE teste01 OWNER TO postgres; \connect teste01 SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; -- -- TOC entry 308 (class 2612 OID 11574) -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres -- CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql; ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- TOC entry 1501 (class 1259 OID 16435) -- Dependencies: 5 -- Name: area; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE area ( id_area integer NOT NULL, codigo smallint NOT NULL, nome character varying(40) ); ALTER TABLE public.area OWNER TO postgres; -- -- TOC entry 1500 (class 1259 OID 16433) -- Dependencies: 1501 5 -- Name: area_id_area_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE area_id_area_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.area_id_area_seq OWNER TO postgres; -- -- TOC entry 1788 (class 0 OID 0) -- Dependencies: 1500 -- Name: area_id_area_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE area_id_area_seq OWNED BY area.id_area; -- -- TOC entry 1789 (class 0 OID 0) -- Dependencies: 1500 -- Name: area_id_area_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('area_id_area_seq', 1, false); -- -- TOC entry 1779 (class 2604 OID 16438) -- Dependencies: 1500 1501 1501 -- Name: id_area; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE area ALTER COLUMN id_area SET DEFAULT nextval('area_id_area_seq'::regclass); -- -- TOC entry 1782 (class 0 OID 16435) -- Dependencies: 1501 -- Data for Name: area; Type: TABLE DATA; Schema: public; Owner: postgres -- INSERT INTO area VALUES (1, 1, 'Almoço'); INSERT INTO area VALUES (2, 2, 'Refeição'); INSERT INTO area VALUES (3, 3, 'Cardápio'); -- -- TOC entry 1781 (class 2606 OID 16440) -- Dependencies: 1501 1501 -- Name: pk_area; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY area ADD CONSTRAINT pk_area PRIMARY KEY (id_area); -- -- TOC entry 1787 (class 0 OID 0) -- Dependencies: 5 -- Name: public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO PUBLIC; -- Completed on 2011-07-30 22:55:45 -- -- PostgreSQL database dump complete --