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 |
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 |