Post non-english symbols

A.A.M.

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>'@

royandre

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!

A.A.M.

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]

troubalex

Thanks for reporting both here and in the bugtracker!

gurudutt

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

gurudutt

This issue is fixed now

गुरुदत्त

troubalex

Nice! Can someone try Chinese and Cyrillic please?

DenisKormalev

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

mgran

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