Reg: invalid byte sequence for encoding utf8 0x00 - Mailing list pgsql-admin

From JSPrabu
Subject Reg: invalid byte sequence for encoding utf8 0x00
Date
Msg-id 006601cb5fb7$51bc7430$f5355c90$@com
Whole thread Raw
Responses Re: Reg: invalid byte sequence for encoding utf8 0x00
List pgsql-admin

Hi Support,

 

Please help for the following issues which I am facing with migration and replication process of oracle to EnterpriseDB database.

 

1)      While migrating tables from oracle to edb database, I am facing invalid byte sequence for encoding utf8” error.

Actually I am migrating through “migration studio”. In this wizard, while doing online migration of oracle table with data’s , constraints and indexes, constraints and indexes are migrated but I am getting this encoding error when migrating table data’s.

 

2)      In xDB replication console also, I am facing this same encoding error.

In one support link, I came to know that we have to add “-DreplaceNullChar=true” and “-DnullReplacementChar=replacement char command in advanced JVM options for replacing “null” value from oracle table to edb table, But I could not find advanced JVM options in xDB replication console.

 

 

Source:

database:                            Oracle 10.2.0.3.0

nls_lang:                              American

nls_characterset:             WE8ISO8859P1

 

target:                 

database:            PostgrePlus 8.4 Advanced server

encoding:            utf8

 

 

 

Thanks & Regards,

-----------------------

Prabu.J.S

Database Administrator  |  iRADcle Solutions.

Handy : +91 978 624 4530  |  Off : 044 44507141

 

 

pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Hot standby server does not start
Next
From: Anuj Pankaj
Date:
Subject: Re: Old database format..