Special Characters? UTf-8

[zigzag]

I'm getting these ¦nbsp;  � appearing in posts - they are appearing with just normal punctuation, I've tried applying the fix here: http://www.simplemachines.org/community/index.php?topic=63187.msg461437#msg461437

I've found this http://www.simplemachines.org/community/index.php?topic=63146.msg437576#msg437576 post as well but it only seems to be applicable to topic titles & last post.

Using Bridge 1.12
Joomla 1.08
Smf 1.1 RC2

[Kindred]

smf does not currently support utf-8.   they are trying to get that all fixed for the 1.1 final relase.

[zigzag]

Hi, Thanks for the reply - guess I'll just keep editing them out till then 

[Elmacik]

zigzag, are your tables in the database set to use UTF8 collations and character sets?
This helped me to solve character problems in SMF.

[zigzag]

Hi,
Yes they are - when I was using 1.06 it I just changed the charset in the language file & it was ok, I've done that with 1.1 RC2 but I still get the funny symbols appearing but oddly (I assume oddly because I don't much about charsets) it's not when any special characters are typed in - they just appear completely at random and sometimes instead of a space the ¦nbsp; appears instead.

[Elmacik]

I didnt mean the *files* of SMF.
I meant the *tables* of the database.
Like running queries like this:

Code Select Expand


ALTER TABLE `smf_tables` DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci;

Where smf_tables is the table names of smf like:
smf_attacments
smf_boards
smf_message...

[zigzag]

Hi,
When I view the databases through php myadmin it says:
latin1_swedish_ci
MySQL charset:  UTF-8 Unicode (utf8)
I took that to mean that it was utf8 (I'm hopless with databases) do I have run queries to convert it?

[Elmacik]

Yes.
Or you have to manually change the character sets & collations from phpMyAdmin
(phpMyAdmin -> SMF DATABASE -> Operations -> Collation)
And so on for all the tables individually.