News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Another UTF8 bug

Started by bulletproof.rs, December 22, 2014, 02:24:39 PM

Previous topic - Next topic

bulletproof.rs

Hello everyone,

i have to report yet another UTF8 problem that i tried a lot of fixes found here and none worked.
The problem is reported here

http://www.simplemachines.org/community/index.php?topic=413735.5
http://www.simplemachines.org/community/index.php?topic=407762
http://www.simplemachines.org/community/index.php?topic=407531


I tried all of the solutions.

I have the line
$db_character_set = 'utf8';
In in my Settings.php

I've checked in phpmyadmin , Collation charset is utf8_general_ci

I've tried this solution:

Quote from: LosElchos on November 05, 2010, 02:25:53 AM
Hello

I had the same problem, but it's easy.
Our forum is in UTF-8 German language but the mysql DB connection from SMF 2.0 RC4 isn't UTF-8.

How too resolve this problem:
- Open your sources/Subs-Db-mysql.php file
- Goto line 360
- change the code

}
if (empty($db_unbuffered))

}
mysql_query("SET NAMES 'UTF8';",$connection);
if (empty($db_unbuffered))


Now it works fine

Sorry for my bad english.
@Developers please fix it !

Greets from germany
Elch

But nothing!

Weird thing is when posting, and click Preview, the letters are displayed fine..

But when i click Post, nothing, it gets deformed.
It's a fresh install of SMF 2.0.9 using Softaculous installer.

Any idea?

Arantor

Well, you don't need to include the change you outline there since SMF itself will do this for you.

I suspect part of your problem is Softaculous, it's long been known that their installer does something to SMF but we never figured out what they're doing... you are strongly advised to use a fresh install yourself.

Kindred

basically, I don't think that SMF has a bug in this respect.
The Softaculous installed version might... but we don't support custom modified versions like that. We support the product that we designed...
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

bulletproof.rs

If a do a backup of database, will i be able to restore it after i do a fresh install without Softaculous?
I  don't want to lose all posts and users :)

Arantor

Possibly, depends what the Softaculous installation did to the database that appears to be somehow nonstandard.

Advertisement: