SMF Support > SMF 1.1.x Support

How do I prevent characters from becoming "?" forever?

(1/6) > >>

stylusss:
Certain characters never get translated properly, how do I prevent this from happening ever again?

I use English-utf8.

Please help me out, this has been bothering so much every since I started my forum years ago.

K@:
You use the utf-8 language files. But, did you actually convert the database to use that?

ziycon:
Make sure that your database is setup with the proper character encoding. Go into phpmyadmin and on the first page it should say 'Server charset:' next go into the database your using for SMF and click the Operations tab and look for 'Collation'. If you could post the two values we can take it from there.

K@:
Good shout, Ziycon! I should've added that bit. :)

stylusss:

--- Quote from: ziycon on August 16, 2012, 07:32:58 AM ---Make sure that your database is setup with the proper character encoding. Go into phpmyadmin and on the first page it should say 'Server charset:' next go into the database your using for SMF and click the Operations tab and look for 'Collation'. If you could post the two values we can take it from there.

--- End quote ---

It says Latin1_swedish_ci...

Also, when I go to convert the database using the forum maintenance, I get the following error:

Database Error: Column 'title' cannot be part of FULLTEXT index
File: /home/.../public_html/Sources/Admin.php
Line: 1343

and the line that corresponds to this is:


--- Code: ---ALTER TABLE $table_info[Name]" . substr($updates_blob, 0, -1), __FILE__, __LINE__);
--- End code ---

Navigation

[0] Message Index

[#] Next page