[pgadmin-support] Data Migration Wizard Problem

2003-03-03 Thread Jim Sharples
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) Rolli

Re: [pgadmin-support] Data Migration Wizard Problem

2003-03-03 Thread Jim Sharples
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

Re: [pgadmin-support] Data Migration Wizard Problem

2003-03-03 Thread 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:04To: [E

Re: [pgadmin-support] Data Migration Wizard Problem

2003-03-03 Thread Dave Page
Title: Message Hi Jim,   Once we ar happy that the Unicode driver is stable, I will make it the default anyway. Do you have the ability to recompile pgSchema yourself?   Regards, Dave. -Original Message-From: Jim Sharples [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 14:45To

Re: [pgadmin-support] Data Migration Wizard Problem

2003-03-03 Thread Jim Sharples
Hi Dave, Yes, I can do it myself - write VB apps for a living. I was in the UK (if that's where you are physically located) at the end of January (business), and thought the weather wasn't too bad. Found out later that it was the warmest January in living memory! And then a few days later it snowe

Re: [pgadmin-support] Data Migration Wizard Problem

2003-03-03 Thread Dave Page
Title: Message   -Original Message-From: Jim Sharples [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 15:39To: Dave Page; [EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Subject: RE: [pgadmin-support] Data Migration Wizard Problem Hi Dave,Yes, I can do it myself - write VB apps f