Databases: PostgreSQL + UTF-8

Databases: PostgreSQL + UTF-8

لە لایەن 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

تێکرایى نمرەپێدراوەکان: -
In reply to 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. چاوداگرتن
تێکرایى نمرەپێدراوەکان: -
In reply to 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).
تێکرایى نمرەپێدراوەکان: -