Databases: PostgreSQL + UTF-8

Databases: PostgreSQL + UTF-8

ved Goran Mekic -
Antal besvarelser: 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

Gennemsnitsbedømmelse: -
I svar til Goran Mekic

Re: Databases: PostgreSQL + UTF-8

ved Eloy Lafuente (stronk7) -
Billede af Core developers Billede af Documentation writers Billede af Moodle HQ Billede af Particularly helpful Moodlers Billede af Peer reviewers Billede af Plugin developers Billede af 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 smiler

P.S.: Moving this to the Databases forum...seems to be a better place to discuss it. blinker
Gennemsnitsbedømmelse: -
I svar til Eloy Lafuente (stronk7)

Re: Databases: PostgreSQL + UTF-8

ved 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).
Gennemsnitsbedømmelse: -