Databases: PostgreSQL + UTF-8

Databases: PostgreSQL + UTF-8

дэргэд Goran Mekic -
Хариу нийтлэлийн тоо: 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

Үнэлгээний дундаж: -
Goran Mekic-н хариуд

Re: Databases: PostgreSQL + UTF-8

дэргэд Eloy Lafuente (stronk7) -
Core developers зураг Documentation writers зураг Moodle HQ зураг Particularly helpful Moodlers зураг Peer reviewers зураг Plugin developers зураг 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 инээмсэглэл

P.S.: Moving this to the Databases forum...seems to be a better place to discuss it. нүд ирмэх
Eloy Lafuente (stronk7)-н хариуд

Re: Databases: PostgreSQL + UTF-8

дэргэд 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).