On Wed, Nov 30, 2011 at 11:53:53AM -0800, James Fillman wrote:
>
> I've just gotten a chance to try and export the oracle db after applying the
> patch you provided. I was able to successfully output a full dump of the
> oracle database. Thanks!
>
> I am, however, running into another problem. This time it's with the
> postgresql import. It bombs out with this error message:
>
> ERROR: invalid byte sequence for encoding "UTF8": 0xeda080
> 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 rhnpackagechangelogdata, line 136452
Actually, I would kinda expect that patch
> diff --git a/utils/spacewalk-dump-schema b/utils/spacewalk-dump-schema index
> 0068ed4..b40593b 100755
> --- a/utils/spacewalk-dump-schema
> +++ b/utils/spacewalk-dump-schema
> @@ -118,8 +118,9 @@ sub process_table {
> } elsif ($types[$i] eq 'unknown' or $types[$i]
> eq 'BLOB') { # blobs
> $row->[$i] =~ s!(.)! sprintf
> "\\\\%03o", ord($1) !seg;
> } else {
> + utf8::encode($row->[$i]);
> $row->[$i] =~ s!([\x00-\x1f\x5c])!
> sprintf "\\x%02x", ord($1) !seg;
> - utf8::encode($row->[$i]);
> utf8::decode($row->[$i]);
> + utf8::decode($row->[$i]);
> }
> print $row->[$i];
> } else {
to address this issue.
What is on that line 136452?
--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
