Re: Data Migration Wizard Problem

-----Original Message-----
From: Jim Sharples [mailto:jim@watagan.com]
Sent: 03 March 2003 10:04
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Data Migration Wizard Problem

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.