Re: Data Migration Wizard Problem

Hi Dave,

I tried creating 2 ODBC connections to a test Unicode database, one using
the standard PostgreSQL driver, and another using the PostgreSQL30W
[PostgreSQL + Unicode (Beta)] driver.

I then used these to create 2 links to the same table in the database in
Access, and added a record using the accented character.

Guess what? The standard driver gave the error as below, but the
PostgreSQL30W driver worked properly!

So, I probably would need to compile a new pgSchema.dll using the other
driver (I checked the source code where the driver is specified). Would
there be some way to dynamically load the correct driver depending on the
database encoding? Or is this a possible future enhancement?

I will also try some experiments using the Unicode driver with a
non-Unicode database etc.

Regards,

Jim Sharples.

At 11:12 AM 3/03/2003 +0000, Dave Page wrote:

>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:jim(at)watagan(dot)com]
>Sent: 03 March 2003 10:04
>To: pgadmin-support(at)postgresql(dot)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.
>
>
>---
>Incoming 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