diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-12-06 20:25:42 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-12-06 20:25:42 +0000 |
| commit | 40c729ae6cbf8c1afbffeb8d1dbfcf9f52eca140 (patch) | |
| tree | f29820f9f547dc1cb1d302881410cbc1f8a2da62 | |
| parent | 363fcbafa133f82c134c21963fdf28d32b4abf20 (diff) | |
| download | postgresql-40c729ae6cbf8c1afbffeb8d1dbfcf9f52eca140.tar.gz postgresql-40c729ae6cbf8c1afbffeb8d1dbfcf9f52eca140.zip | |
Highlight diff idea for iconv.
| -rw-r--r-- | doc/src/sgml/release.sgml | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 0feacc1ec64..18a1b182805 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.405 2005/12/06 20:19:17 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.406 2005/12/06 20:25:42 momjian Exp $ Typical markup: @@ -532,10 +532,12 @@ psql -t -f fixseq.sql db1 | psql -e db1 8.1.X. This is because previous versions allowed invalid <literal>UTF8</> sequences to be entered into the database, and this release properly accepts only valid <literal>UTF8</> sequences. One - way to correct a dumpfile is to use <command>iconv -c -f UTF-8 -t UTF-8</>. - This will remove invalid character sequences. <command>iconv</> - reads the entire input file into memory so it might be necessary to - <command>split</> the dump into multiple smaller files for processing. + way to correct a dumpfile is to use <command>iconv -c -f UTF-8 -t UTF-8 + -o cleanfile.sql dumpfile.sql</>. The <literal>-c</> option removes + invalid character sequences. A diff of the two files will show the + sequences that are invalid. <command>iconv</> reads the entire input + file into memory so it might be necessary to <command>split</> the dump + into multiple smaller files for processing. </para> </listitem> |