4 users online. Create an account or sign in to join them.Users
install.php: UTF-8 warning
A for , submitted by phoque on 25 January 2010
Announcement
Symphony's issue tracker has been moved to Github.
Issues are displayed here for reference only and cannot be created or edited.
Browse
Closed#214: install.php: UTF-8 warning
-
-
- phoque
- Comment #1
- 25 Jan 10, 7:58 pm
-
-
- Allen
- Comment #2
- 26 Jan 10, 9:16 am
You need to make sure both your table and your database collation are set correctly. If you only make sure your existing tables are UTF-8, your new tables will still be created using the default database collation.
-
-
- phoque
- Comment #3
- 04 Feb 10, 4:26 am
Oh, of course you are right. Then it must check if the database is UTF8-capable on installation.
-
-
- Alistair
- Comment #4
- 19 Mar 10, 6:52 pm
This really isn’t the job of the installer, and we would prefer the installer does not assume what encoding/collation the user wants or needs. Furthermore, the problem can be easily solved by properly setting the defaults on your server.
This issue is closed.
As the UTF-8-issues are starting to become more frequent I would suggest a new feature for install.php:
Either before or after running the installation procedure it should display a warning if the created tables or the database aren’t capable of saving UTF-8.
I am not sure why MySQL sometimes won’t use UTF-8 for new tables (maybe if the database is set to some Latin-derivative?). If we can figure out the reason for this behaviour, we can warn even before the installation is commenced. Or, if we can’t, the warning could be displayed after creating (and checking for correct creation afterwards) the tables.