Search Postgresql Archives

Re: invalid byte sequence for encoding "UTF8"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wednesday 21 March 2007 04:17, "Fuzzygoth" <dav.phillips@xxxxxxxxxxxx> 
wrote:
> I've searched the forums and found people with similar problems but
> not much
> on a way to remedy it. I did try using iconv which was suggested in a
> thread
> but it returned an error saying even the 22GB file was too large to
> work on.

iconv needs to read the whole file into RAM.  What you can do is use the 
UNIX split utility to split the dump file into smaller segments, use iconv 
on each segment, and then cat all the converted segments back together into 
a new dump file.  iconv is I think your best option for converting the dump 
to a valid encoding.

-- 
"None are more hopelessly enslaved than those who falsely believe they are
free." -- Johann W. Von Goethe



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux