Postgres Pro
Downloads
Home   >   mailing lists

Changing text encoding rapidly - Mailing list pgsql-general

From Philippe Kiener
Subject Changing text encoding rapidly
Date
Msg-id 002301c2d8e5$5602a700$c548c00a@tcom.eivd.ch
Whole thread Raw
List pgsql-general
Tree view
Hello
I run a web site that used to use the iso-8859-1 encoding.
I have stored a lot of string in a lot of different table with php. All those strings are now store as iso-8859-1 in my database.
I would like now to encode all the text field of my database to UTF-8, because I would like my site to use UTF-8 encoding. Is there a quick way to encode from iso-8859-1 to UTF-8 all my text and varchar field of all my tables with a utility?
 
Thanks for your help
Greetings
Philippe Kiener

pgsql-general by date:

Previous
From: "Mark Cave-Ayland"
Date:
Subject: Re: 7.3.1 takes long time to vacuum table?
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: 7.3.1 takes long time to vacuum table?