error/admin/unicoderequired: Difference between revisions
From MoodleDocs
Helen Foster (talk | contribs) (see also, stub template, categories) |
Tim Bahula 2 (talk | contribs) m (→top: clean up, typos fixed: a utf8 → an utf8 (2)) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 3: | Line 3: | ||
::It is required that you store all your data in Unicode format (UTF-8). New installations must be performed into databases that have their default character set as Unicode. If you are upgrading, you should perform the UTF-8 migration process (see the Admin page). | ::It is required that you store all your data in Unicode format (UTF-8). New installations must be performed into databases that have their default character set as Unicode. If you are upgrading, you should perform the UTF-8 migration process (see the Admin page). | ||
I'm doing this on a postgresql 7.4 server (debian etch), which apparently does not default to creating the database with | I'm doing this on a postgresql 7.4 server (debian etch), which apparently does not default to creating the database with an utf8 encoding. | ||
To resolve the issue, i switched to the postgresql user, removed the old database, and recreated the new one, with | To resolve the issue, i switched to the postgresql user, removed the old database, and recreated the new one, with an utf8 encoding: | ||
postgres@mongoose:~$ dropdb moodle | postgres@mongoose:~$ dropdb moodle | ||
| Line 12: | Line 12: | ||
CREATE DATABASE | CREATE DATABASE | ||
postgres@mongoose:~$ | postgres@mongoose:~$ | ||
I've [[User:Jeff Forssell|Jeff Forssell]] 09:56, 18 November 2008 (CST) gotten the same error message (though black text on bright red), but I'm on a SiteGround Host with MySQL. I thought we'd already gone through the UTF-8 conversion process, so I'm a bit surprised and don't know what to do. | |||
==See also== | ==See also== | ||
| Line 21: | Line 23: | ||
[[Category:Error|Admin]] | [[Category:Error|Admin]] | ||
[[Category:UTF-8|Error]] | [[Category:UTF-8|Error]] | ||
[[es:error/admin/unicoderequired]] | |||
Latest revision as of 14:41, 11 August 2022
I'm getting this error on a new moodle 1.8.2+ installation (package pulled 2007-09-05). It reads, in full (in horrible light-grey-on-light-red colors):
- It is required that you store all your data in Unicode format (UTF-8). New installations must be performed into databases that have their default character set as Unicode. If you are upgrading, you should perform the UTF-8 migration process (see the Admin page).
I'm doing this on a postgresql 7.4 server (debian etch), which apparently does not default to creating the database with an utf8 encoding.
To resolve the issue, i switched to the postgresql user, removed the old database, and recreated the new one, with an utf8 encoding:
postgres@mongoose:~$ dropdb moodle DROP DATABASE postgres@mongoose:~$ createdb -E utf8 -O www-data moodle CREATE DATABASE postgres@mongoose:~$
I've Jeff Forssell 09:56, 18 November 2008 (CST) gotten the same error message (though black text on bright red), but I'm on a SiteGround Host with MySQL. I thought we'd already gone through the UTF-8 conversion process, so I'm a bit surprised and don't know what to do.
See also
