next »

[Muumipappa]

I've finally updated bot to 1.7.1 from 1.5.1
Now for some reason im missing Ä, Ö and Å in chatlogger and in echelon.

I tracked it down to this in my b3.log

Code:

111122 12:31:31 VERBOSE 'Queueing event Say iltap\xe4iv\xe4\xe4'
111122 12:31:31 VERBOSE 'Parsing Event: Say: ChatloggerPlugin'
111122 12:31:31 DEBUG 'ChatloggerPlugin: ALL, 751, SadPanda, iltap\xe4iv\xe4\xe4'
111122 12:31:31 ERROR 'STDERR "D:\\\\bbb3\\\\b3_Mixed\\\\b3\\\\storage\\\\database.py:260: Warning: Incorrect string value: \'\\\\xE4iv\\\\xE4\\\\xE4\' for column \'msg\' at row 1\\n  cursor.execute(query, bindata)\\n"'
111122 12:31:31 DEBUG 'ChatloggerPlugin: rowcount: 1, id:32'

xe4 is Ä right there. Same thing happens with Ö which is xf6

Code:

111122 12:31:11 VERBOSE 'Queueing event Say \xf6\xf6\xf6\xf6\xf6'
111122 12:31:11 VERBOSE 'Parsing Event: Say: ChatloggerPlugin'
111122 12:31:11 DEBUG 'ChatloggerPlugin: ALL, 2, |ML|Muumipappa, \xf6\xf6\xf6\xf6\xf6'
111122 12:31:11 ERROR 'STDERR "D:\\\\bbb3\\\\b3_Mixed\\\\b3\\\\storage\\\\database.py:260: Warning: Incorrect string value: \'\\\\xF6\\\\xF6\\\\xF6\\\\xF6\\\\xF6\' for column \'msg\' at row 1\\n  cursor.execute(query, bindata)\\n"'

Any ideas how to fix this?
All worked well before bot update.

[Muumipappa]

Now that i left 1.7.1 database and just ran bot with old 1.5.0 files, all scandinavian characters work just fine.
No changes made to database collation.
All tables and database is set to utf8_general_ci or utf8_unicode_ci.

There must be something what has changed way it handles ä and ö and å in 1.7.1 database.py?

[82ndAB.Bravo17]

There were changes made in 1.6 I think that would have caused this, COD4 seems to be affected most by it.

If you want you could download the latest files from xlr8ors repo and try those and see if that fixes it.

http://forum.bigbrotherbot.net/index.php?action=downloads;sa=view;down=5

There is an extra entry in the b3 xml files to set the encoding that you use.

      <set name="encoding">latin-1</set>   (Use your codepage instead of latin-1)

It goes in the server section of the xml.

Please report back with any results, if you try it.

[Muumipappa]

That fixed my problem 
Thank you 

I didn't test it with utf8 or with any other settings tho, cos our collation and codepage at the north pole mostly is Latin-1