4 for those of you who used sourceforge and now use gforge with the same database,
5 you probably noticed that if the language of the site was something other then
6 english the strings stored in the db are now not displayed correctly because
7 of the new coding mechanism used by gforge which is UTF-8. Here is how you can
8 transform the encoding of your database to make it work. That exemple will work
9 if your site used only one type of language for exemple latin1.
11 If you want to convert your db so that the strings will be displayed correctly,
13 1) dump your existing db
14 2) Create a new db with UTF-8 encoding:
15 createdb -E UNICODE your_new_db_name
16 3) Convert your dump with iconv (in that exemple, all strings were
18 iconv -f iso-8859-1 -t utf-8 your_database_dump > database_dump_converted
19 4) Load your dump into the db using:
20 psql -d your_new_db_name -f database_dump_converted