From: | Dave Lazar <hunkybill(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Encoding and Conversion Question(s) |
Date: | 2005-08-15 18:15:19 |
Message-ID: | e0d71d27050815111517e0df71@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have a database that was created with the encoding set to SQL_ASCII.
A lot of data comes with accented characters. When reading this data
with PHP, and using utf-8 as my broweser output charset, any accented
characters are displayed as weird symbols. If I use the PHP function
utf8_encode() around the data, it all looks fine again.
So, I have decided to simply change the encoding of my database from
SQL_ASCII to UNICODE so that I do not need to use utf8_enocde() in
PHP.
I did a pg_dump of my database. I then created a blank database with
UNICODE as the encoding. However, pg_restore chokes with a message
about not being able to convert a multibyte character properly.
My server settings are en-US.UTF-8 for lc_collate and server encoding
is set to UNICODE.
How can I reload all my data into the UNICODE database I have created?
Is there something to do with the dump? I hope not!! Any tips on this
most appreciated!!
TIA
Dave
From | Date | Subject | |
---|---|---|---|
Next Message | CSN | 2005-08-15 18:28:00 | Re: Apostrophe doesn't show up in command line |
Previous Message | Joshua D. Drake | 2005-08-15 18:06:08 | Re: error inserting big files in DB. |