Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 1492E1336FA7 for ; Wed, 29 Sep 2010 06:23:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 57789-06 for ; Wed, 29 Sep 2010 09:23:26 +0000 (UTC) X-Greylist: delayed 00:06:39.923551 by SQLgrey-1.7.6 Received: from smtpauth04.prod.mesa1.secureserver.net (smtpauth04.prod.mesa1.secureserver.net [64.202.165.95]) by mail.postgresql.org (Postfix) with SMTP id EC33D1337B55 for ; Wed, 29 Sep 2010 06:23:25 -0300 (ADT) Received: (qmail 5146 invoked from network); 29 Sep 2010 09:16:45 -0000 Received: from unknown (122.183.185.194) by smtpauth04.prod.mesa1.secureserver.net (64.202.165.95) with ESMTP; 29 Sep 2010 09:16:43 -0000 From: "JSPrabu" To: Cc: Subject: Reg: invalid byte sequence for encoding utf8 0x00 Date: Wed, 29 Sep 2010 14:48:42 +0530 Message-ID: <006601cb5fb7$51bc7430$f5355c90$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0067_01CB5FE5.6B74B030" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Actft0x2EmQRb7irSBqE+PGvs6Ry6g== Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201009/182 X-Sequence-Number: 35726 This is a multipart message in MIME format. ------=_NextPart_000_0067_01CB5FE5.6B74B030 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0067_01CB5FE5.6B74B030 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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=3Dtrue” and “-DnullReplacementChar=3Dreplacement 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: = ; = &= nbsp; Oracle 10.2.0.3.0

nls_lang: = ; = &= nbsp; American

nls_characterset: &nb= sp; = WE8ISO8859P1

target: &= nbsp; =

database: = ; PostgrePlus 8.4 Advanced server

encoding: &n= bsp; utf8

Thanks & Regards,

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

Prabu.J.S

Database Administrator | iRADcle = Solutions.

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

------=_NextPart_000_0067_01CB5FE5.6B74B030--