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).
評点平均: -