Databases: PostgreSQL + UTF-8

Databases: PostgreSQL + UTF-8

by Goran Mekic -
Number of replies: 2

In PostgreSQL UTF-8 does not exist, only UTF8, and Moodle complains about it. If I skip encoding test, generated HTML is ISO-8859-1, but if I enforce encoding to be UTF-8 (in firefox), everything is ok. Moodle says UTF8 is outdated, and we should use UTF-8. Can you fix this?

Moodle: CVS version (1.6)

PostgreSQL: 8.x

Average of ratings: -
In reply to Goran Mekic

Re: Databases: PostgreSQL + UTF-8

by Eloy Lafuente (stronk7) -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Testers
Hi Goran,

if I'm not wrong Moodle will look, under Postgres, if DB encoding is one of these: UTF8, UNICODE (that are equivalet).

If any of them are detected, then Moodle is automatically set to work under UTF-8 mode, where everything (interface, DB and http headers are all properly set).

I really don't understand your problem, the skip encoding test is only available for people performing new installations of Moodle that aren't able to switch their DB to Unicode.

Can you explain a bit more your problem?

Ciao smile

P.S.: Moving this to the Databases forum...seems to be a better place to discuss it. wink
Average of ratings: -
In reply to Eloy Lafuente (stronk7)

Re: Databases: PostgreSQL + UTF-8

by Goran Mekic -
Moodle is looking for UTF-8, and when it comes to PostgreSQL, unicode is called UTF8. Moodle complains it is deprecated unicode encoding. Sorry for not being able to reproduce the error, I need it working to complete an univercity project. I hope I will give you screenshot and listing of all PostgreSQL databases available on my system, as soon as I finish this project (about 2 weeks).
Average of ratings: -