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.
- -2147467259: ERROR: Invalid UNICODE character sequence found (0xe90020)
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.
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/2003
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
