From: | Ralph Smith <smithrn(at)washington(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8 |
Date: | 2008-02-26 21:26:58 |
Message-ID: | 597B52AB-54C0-44A8-BCD3-5417F2A1A24D@washington.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm not sure if you're saying I should ignore these errors...
I'm using dumps from DB airaburst.
>postgres=# \l
List of databases
Name | Owner | Encoding
------------+----------+-----------
airburst | root | SQL_ASCII
lt_dev1 | postgres | UTF8
lt_dev2 | postgres | UTF8
lt_reports | postgres | UTF8
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
(7 rows)
============================================
Looking at the dump of one table there...
--
-- PostgreSQL database dump
--
-- Started on 2008-02-25 12:28:48 PST
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- TOC entry 1455 (class 1259 OID 20378)
-- Dependencies: 1839 2
-- Name: board_posts; Type: TABLE; Schema: public; Owner: airburst;
Tablespace:
============================================
The error I get on trying to import it.
postgres(at)flexo:~/WORKING_DATA/airburst_tables$ psql lt_dev1 -f ./
table_board_posts.sql
SET
SET
SET
SET
SET
SET
SET
SET
CREATE TABLE
ALTER TABLE
psql:./table_board_posts.sql:248: ERROR: invalid byte sequence for
encoding "UTF8": 0x91
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".
CONTEXT: COPY board_posts, line 8
CREATE INDEX
Thank you!
From | Date | Subject | |
---|---|---|---|
Next Message | Gevik Babakhani | 2008-02-26 21:30:02 | Re: win32: how to backup (dump does not work) |
Previous Message | Tom Hart | 2008-02-26 21:04:05 | Re: utf8 issue |