Hello,
I install SMF 2.0.6 on mysql 5.6.11. The date display � instead of ,.
SMF 2.0.6 with mysql 5.1 was ok, which was my previous environment.
I am running XAMPP 1.8.3 on a Win 7 PC.
Apache 2.4.4
MySQL 5.6.11
PHP 5.5.3
Please help.
Maybe not a SMF bug, but a mysql 5.6.11 bug?
mmm... as far as I remember a comma is not a special char of any type.
Did you select UTF8 while installing?
Is this the only "artifact" or there are others?
Did you change the time format somewhere?
As a guest do you see it broken?
Yes, I did select UTF-8 during the installing.
When creating a database, I selected <UTF8_bin> with phpmyadmin.
What about the other questions asked?
mmm... UTF8_bin? For the collation?
I think it is generally better to use general_ci to use with SMF (at least because I seem to remember bin is case sensitive, while SMF assumes mysql to be case insensitive, but I may be wrong).
Well, anyway that should be a detail (in theory and if the few I understand about collation and charset is not *so* wrong).
Yep, answer to the other questions was more important. :)
You're right about the collation, though AFAIR the installer should be indicating a _ci collation itself ;)
I installed another SMF 2.0.6 on the same PC environment. The issue still persisted.
When I was creating a database with phpmyadmin, I use <collation> this time, which is the default value.
The default time format is : %B %d， %Y， %I:%M:%S %p
All posts' data now display like this : ?��???11�?2013�?09:52:55 pm
I would suspect it more like a mysql's issue.
Best Regards
So, what language pack was being used?
Bump. If no response within 7 days I'll consider it closed.
Closed.