By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,116 Members | 1,319 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,116 IT Pros & Developers. It's quick & easy.

encoding question

P: n/a

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

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!!


Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.