Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support

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 

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?


Jim Sharples.

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group