Data Migration Wizard Problem

From: Jim Sharples <jim(at)watagan(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Data Migration Wizard Problem
Date: 2003-03-03 10:03:56
Message-ID: 5.1.0.14.2.20030303193600.00aadc48@mail.watagan.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

I am trying to migrate a MS SQL7 database to Postgres. The Postgres
database is UNICODE, and whenever the Migrator encounters an é character, I
get an error as follows:
An error occured at: 3/03/2003 1:36:32 PM:
-2147467259: ERROR: Invalid UNICODE character sequence found (0xe90020)

Rolling back... Done.

sometimes the error is:
-2147467259: ERROR: Invalid UNICODE character sequence found
(0xe90000)

The actual statement (captured in debug) is:

INSERT INTO "member" ("memberid", "famname", "othername", "title",
"streetaddr", "suburb", "city", "state", "postcode", "email", "dob", "age",
"gender", "privacydate", "deleted", "enterdate", "enterby", "check1",
"check2") VALUES ('XSY0101693', 'Blasé', 'Lisa M', '', 'Unit 15 46 Albany
Creek Rd', 'ASPLEY', '', 'QLD', '4034', '', '1969-06-25 00:00:00', '32', '
', '2001-12-24 00:00:00', '0', '2003-02-24 12:29:44', 'Transfer', '0', '0')

The import works fine until it hits this accented é character, which should
be valid for Unicode I presume? I also tried using the escape sequence
"\351", but that returned the same error.

If I create the table with SQL_ASCII encoding, then I don't get the error.

Any ideas?

Thanks,

Jim Sharples.

Attachment Content-Type Size
unknown_filename text/plain 169 bytes

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2003-03-03 11:12:38 Re: Data Migration Wizard Problem
Previous Message Dave Page 2003-03-01 16:56:27 Re: Database Migration