Foreign Languages

[IceXaos]

I have installed and switched all users to English UTF-8, though I'm still unable to post in other languages.  An example would be attempting to post Русский and getting ? once posted, but it does show correctly in a preview.

[Illori]

do you have your database utf-8?

[IceXaos]

Changed database collation to uft8_general_ci and the problem persists.

To be exact:

Code Select Expand

ALTER DATABASE `MYDATABASE` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

[IceXaos]

Before I select the language, it says the character set for it is UTF-8, but once I select it, it changes to ISO-8859-1.

[IceXaos]

Okay, it's the database somehow because I attempted converting to UTF-8 from HTML entities and it changed them to ?'s.  I also tried to use an UPDATE query setting the body to use Cyrillic characters, and it gave an error:

Code Select Expand

0 row(s) affected.
Warning: #1366 Incorrect string value: '\xD0\xA0\xD1\x83\xD1\x81...' for column 'body' at row 1

I'm not sure what to do.  The overall database is set to utf8 general ci as well as the messages table.

[IceXaos]

Figured out the column was still latin.  I just gotta figure out how to change all tables/columns to utf8 general and I'm good to go.  Any ideas on how to do this?

[IceXaos]

got it

[IceXaos]

Sorry for all the spam, but posting as I do things helps me think of solutions.

[NanoSector]

Sorry for all the spam, but posting as I do things helps me think of solutions.

Haha lol I can see

Good you got it solved though.