You used __ initdb -E UTF8 when you initialized the cluster? I did this and it works just fine. What happens when you use pg_dump to dump the database? The first few lines of the dump will tell you what the encoding is. Interesting that the docs say that you can use the createdb -E UTF-8 and have multiple encodings.
but look at this line from the docs: Since these locale settings are frozen by initdb, the apparent flexibility to use different encodings in different databases of a cluster is more theoretical than real. It is likely that these mechanisms will be revisited in future versions of PostgreSQL. I actually have the problem with a dump and restore. When I look at the dump file, I see the accented charcters 'é'. This will not import with psql databasename <dumpfile. I first have to open the dump file in bbedit and replace the accented characters with \203\207 (these are not real numbers). One day I will figure out why the dump is not happening correctly. Ted --------------------------- > > Message: 1 > Date: Fri, 23 Dec 2005 17:42:59 +0000 > From: Catarina Vieira Simoes <[EMAIL PROTECTED]> > Subject: UTF-8 and PostgreSQL problem > To: WebObjects-List Apple > <[email protected]> > Message-ID: > <[EMAIL PROTECTED]> > Content-Type: text/plain; charset=ISO-8859-1; > delsp=yes; format=flowed > > Hi! > > I'm currently developing a web application in Web > Objects using > PostgreSQL 8.0.4 to store the data. The application > must support > accentuated characters so I followed all the > instructions included in > Practical WebObjects book related to UTF-8 support. > Everything works except the data stored and read > from the database. > The accentuated characters appear all messed up, > even when browsing > the table in EOModeler and using the psql command > line utility. > I suppose the problem is in the conversion to and > from SQL queries > and results, but I was unable to set the encoding > used by > PostgreSQLPlugin to UTF-8. The database was created > with the -E > UNICODE flag. > Any ideas? :) > > Happy Holidays! > > Sincerely, > > Catarina Simões __________________________________ Yahoo! for Good - Make a difference this year. http://brand.yahoo.com/cybergivingweek2005/ _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
