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