News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

date display wrong - SMF 2.0.6 mysql 5.6.11

Started by Barlos, November 14, 2013, 04:59:34 AM

Previous topic - Next topic

Barlos

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.

Burke ♞ Knight


emanuele

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?


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Barlos

Yes, I did select UTF-8 during the installing.

When creating a database, I selected <UTF8_bin> with phpmyadmin.

Arantor


emanuele

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. :)


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Arantor

You're right about the collation, though AFAIR the installer should be indicating a _ci collation itself ;)

Barlos

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

Arantor


Arantor

Bump. If no response within 7 days I'll consider it closed.

Arantor


Advertisement: