Re: [pgadmin-support] Data Migration Wizard Problem

[Dave Page]

Title: Message

Hi Jim,

 

That error is coming from PostgreSQL, but I do not know why (but then I know nothing about Unicode). Jean-Michel, do you have any ideas?

 

Regards, Dave.

-----Original Message-----
From: Jim Sharples [mailto:[EMAIL PROTECTED]
Sent: 03 March 2003 10:04
To: [EMAIL PROTECTED]
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.