bbAntiSpam: Discuss how to stop web spam

[Freeze]

Hello,

My Textual Confirmation is unable to display the cyrillic (Russian) characters on the new user registration page of phpBB forum. All questions in Russian which were entered into Textual Confirmation are displayed as "??????" on that page. In all other places of my phpbb forum the Rusian characters are displayed correctly.

I've tried to add the questions to the database using the Textual Confirmation page of administrative area of the forum as well as directly by using the INSERT INTO query - no luck in booth cases.

Please advice how to solve his problem?

[admin]

Textual Confirmation doesn't know about encodings, it uses the standard services of phpBB. Therefore, if your forum correctly works with Russian, then Textual Confirmation also should work with Russian correctly.

Give the link to your forum, I'll look at it and try guess what's the problem you have.
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!

[Guest]

The forum is:

http://chemtable.com/forum

[admin]

My first impression that the forum looks ok. Let's try the following:

*) What's the language of the Administrator? If English, try to switch to Russian.

*) Do you use some "smart" browser like Internet Explorer? Many of them try to guess an encoding. Make sure that the frame where you edit questions uses windows-1251 encoding.

*) Can you correctly edit other (non-Textual Confirmation) texts, such as the forum name?
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!

[Freeze]

[admin]

Yes, I think the database encoding is the problem. I also had a similar problem recently: http://uucode.com/blog/2007/11/25/russian-any-language-in-wordpress/.

I don't know mysql well, therefore can't suggest the exact options for mysql. But I hope that with the help of phpMyAdmin you can detect the right way.

I'd suggest you to look at the Russian phpBB forum. For example, I found this topic: http://phpbbguru.net/community/topic1142.html.
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!

[Freeze]

Thank you for your answers.

I've solved the problem (although the solution is quite strange). I've noticed when logging to phpMyAdmin that all tables related to phpBB except "phpbb_textual_confirmation" has encoding "latin1_swedish_ci" and only the last one has "cp1251_general_ci". I've changed the encoding of the table "phpbb_textual_confirmation" to "latin1_swedish_ci" and now it works correctly with cyrillic characters (a bit strange solution, isn't it?).

[admin]