Post non-english symbols

? Offline

Hi all!

I'm not sure that this is a bug, maybe it's just a feature. Then I'm trying to post a message (on this forum) which contains non-latin symbols (e.g. cyrillic) then I'm getting an following error as a result:

@A Database Error Occurred
Error Number: 1267
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
SELECT COUNT(*) AS count FROM exp_forum_topics WHERE body = '<russian_symbols_here>'@

? Offline

Ough, definitely a bug.

Please file a bug report here, together with the characters you are trying to post:
"http://bugreports.qt.nokia.com/secure/IssueNavigator.jspa?reset=true&mode=hide&pid=10550&sorter/order=DESC&sorter/field=priority&resolution=-1&component=19265":http://bugreports.qt.nokia.com/secure/IssueNavigator.jspa?reset=true&mode=hide&pid=10550&sorter/order=DESC&sorter/field=priority&resolution=-1&component=19265

Thanks!

? Offline

I've submitted a report - "QTWEBSITE-50":http://bugreports.qt.nokia.com/browse/QTWEBSITE-50

IrQX

[quote author="A.A.M." date="1278960118"]Hi all!

I'm not sure that this is a bug, maybe it's just a feature. Then I'm trying to post a message (on this forum) which contains non-latin symbols (e.g. cyrillic) then I'm getting an following error as a result:

@A Database Error Occurred
Error Number: 1267
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
SELECT COUNT(*) AS count FROM exp_forum_topics WHERE body = '<russian_symbols_here>'@[/quote]

I confirm this bug.

[quote]
A Database Error Occurred

Error Number: 1267

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

SELECT COUNT(*) AS count FROM exp_forum_topics WHERE body = 'russian_word_\n\nThis is a test.'
[/quote]

? Offline

Thanks for reporting both here and in the bugtracker!

? Offline

This issue is almost fixed and hopefully will be available after update.

? Offline

This issue is fixed now

गुरुदत्त

? Offline

Nice! Can someone try Chinese and Cyrillic please?

DenisKormalev

Cyrillic test:
Просто тест, ничего более.

? Offline

Looking good, although not all formatting code works for it yet, got that on the list.