Looking deeper into the matter (which I admit I am a bit ignorant on) I think you hit the nail on the head. Coming from MSSQL which is using Latin I may have to use Latin1. It works ok as SQL_ASCHII, but lower does not work, so hopefully using LATIN1 I can store the chars and also get lower to work etc.
Thanks so much for the help. I have been very confused as I could create a Unicode db and even save the French values using pgadmin or .net connection, but the odbc would not work. I hope it works ok with the LATIN1. -----Original Message----- From: Aarni Ruuhimäki [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 10:25 AM To: Joel Fradkin Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] trrouble inserting stuff like é Hi, I use LATIN1 encoding and it works fine with accented characters. So try creating your db with -E LATIN1 switch. Or even initdb -E LATIN1 if you wan't your dbs default to that. Best regards, Aarni On Friday 18 February 2005 16:59, you wrote: > I wrote a program to read my database (from MSSQL) and write it to > Postgres. It appeared to work great the first time I ran it, but the > database was SQL_ASCII (It defaulted to this when I created it from the > command line on the linux box using createdb. > > When I tried to restore it I used PGAdmin on my XP machine which created a > Unicode database. > I was unable to restore the SQL_ASCII to the Unicode, so I re-ran my import > on a Unicode database. > Now I get all kinds of errors from the .net program (which I have write out > the actual SQL on each error). > When I cut and paste the SQL into PGADMIN it runs ok, so it only gives an > error using .net ODBC. > > Any one have any clues for me to follow? > > Here is an example of a SQL line that did not run in .net. > > insert into > tblSuspectedActivity(ClientNum,ID,Value,IsDeleted,PresentationID) > values('FREN',4,'Paiement à > account',False,2) > > Joel Fradkin > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly -------------- This is a bugfree broadcast to you from **Kmail** on **Fedora Core 2** linux system -------------- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
