Problem with polish character set on new install [message #28446] |
Tue, 25 October 2005 10:43 |
bialy
Messages: 2 Registered: October 2005
Karma:
|
Junior Member |
|
|
Hi,
I've got FUDforum installed on one server, about 600 messages, and everything works just fine. I must move it to the new server, and taht's the problem.
I've installed FUD 2.7.3RC3 on new server (same as on old) and everything went just fine, but when I'm trying to post a message with some polish characters the error message is shown:
(/home/grzegorz/domains/hermetic-club.com/public_html/forum/index.php:200
/home/grzegorz/domains/hermetic-club.com/public_html/forum/theme/default/post.php:2763
/home/grzegorz/domains/hermetic-club.com/public_html/forum/theme/default/post.php:1656
/home/grzegorz/domains/hermetic-club.com/public_html/forum/theme/default/post.php:3879
/home/grzegorz/domains/hermetic-club.com/public_html/forum/index.php:1181
) 1270: Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (latin2_general_ci,COERCIBLE), (latin2_general_ci,COERCIBLE) for operation ' IN '
Query: INSERT INTO fud26_index (word_id, msg_id) SELECT id, 2 FROM fud26_search WHERE word IN('odp','ąśćęś')
_GET: array ( 't' => 'post', )
_POST: array ( 'msg_subject' => 'Odp: ???', 'msg_icon' => '', 'fnt_size' => '', 'fnt_color' => '', 'fnt_face' => '', 'msg_body' => 'ąśćęś', 'tmp_f_val' => '1', 'msg_poster_notif' => 'Y', 'msg_show_sig' => 'Y', 'minimsg_pager_switch' => '0', 'S' => '383b7d7d6fd41a90b7b83d9e637fd383', 'SQ' => 'b0b949ecdc20c8b53c00dfce70496cca', 'submitted' => '1', 'reply_to' => '1', 'th_id' => '1', 'frm_id' => '1', 'start' => '0', 'msg_id' => '0', 'pl_id' => '0', 'old_subject' => 'Odp: ???', 'prev_loaded' => '1', 'btn_submit' => 1, )
Server Version: 4.1.10-standard
I think this is something to do with MySQL, but... on first server (where everything works) collation on database and all tables is latin1_swedish_ci. On new server (when the error is produced) default collation of database is latin2_general_ci, which I've changed to latin1_swedish_ci, but error is still showing.
Can you tell me what I'm doing wrong? Or maybe it's problem with new server configuration?
Best regards,
|
|
|