Re: UTF-8 and PostgreSQL problem
Re: UTF-8 and PostgreSQL problem
- Subject: Re: UTF-8 and PostgreSQL problem
- From: Theodore Petrosky <email@hidden>
- Date: Sat, 24 Dec 2005 06:46:36 -0800 (PST)
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@hidden>
> Subject: UTF-8 and PostgreSQL problem
> To: WebObjects-List Apple
> <email@hidden>
> Message-ID:
> <email@hidden>
> 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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden