Nice, updated. ---------------------------------------------------------------------------
Peter Eisentraut wrote: > Bruce Momjian wrote: > > One nice solution would be if iconv would report the lines with > > errors and you could correct them, but I see no way to do that. The > > only thing you could do is to diff the old and new files to see the > > problems. Is that helpful? Here is new text I have used: > > I think this is nice. It users see a big mess, they will have to clean > it up by hand anyway. > > How about this for better wording: > > diff -u -3 -p -r1.400.2.4 release.sgml > --- doc/src/sgml/release.sgml 6 Dec 2005 20:26:02 -0000 1.400.2.4 > +++ doc/src/sgml/release.sgml 6 Dec 2005 20:44:26 -0000 > @@ -528,15 +528,16 @@ psql -t -f fixseq.sql db1 | psql -e db1 > > <listitem> > <para> > - Some users are having problems loading <literal>UTF8</> data into > - 8.1.X. This is because previous versions allowed invalid > <literal>UTF8</> > + Some users are having problems loading UTF-8 data into > + 8.1.X. This is because previous versions allowed invalid UTF-8 byte > 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 > + properly accepts only valid UTF-8 sequences. One > + way to correct a dumpfile is to run the command <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 > + file into memory so it might be necessary to use <command>split</> > + to break up the dump > into multiple smaller files for processing. > </para> > </listitem> > > -- > Peter Eisentraut > http://developer.postgresql.org/~petere/ > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly