Topic: Problems with cyrillic after updating from 1.2.20 to 1.3
Update went fine. No problems at all, however after update was finished Cyrillic become all messed up.
See pic
1 2008-11-13 02:27 (edited by snapsolutions 2008-11-13 02:35)
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
I think it's something about unknown characters going through some special process on the db update. I've read something about that somewhere on the forum.
3 2008-11-13 02:38 (edited by snapsolutions 2008-11-13 02:38)
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
I am searching the forums, but no luck so far 
Thanks though.
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
Anyone?
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
*bump*
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
snapsolutions wrote:
Update went fine. No problems at all, however after update was finished Cyrillic become all messed up.
Database update script asks the initial (1.2) database encoding. For example, if your forum database encoding is WIN-1251 (russian charset) you should write "cp1251".
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
OK, and what do I do in this case:
8 2008-11-14 19:57 (edited by lexazloy 2008-11-14 19:59)
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
First. In file include/dblayer/common_db.php find:
$forum_db = new DBLayer($db_host, $db_username, $db_password, $db_name, $db_prefix, $p_connect);
ater add:
$forum_db->query('set names utf8');And second. Try change collation to "utf8_general_ci".
Royal Crown Chinpoko Master, ^_^
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
snapsolutions wrote:
OK, and what do I do in this case
Well, let's try...
The list of acceptable values: http://www.gnu.org/software/libiconv/do … ESCRIPTION
ISO-8859 encodings: http://en.wikipedia.org/wiki/ISO/IEC_8859
Seems that you need "ISO-8859-10". I would try different values (after making database and files backup, of course).
10 2008-11-15 11:46 (edited by w00t 2008-11-15 11:48)
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
Nothing written above worked for me.
Now I wrote the SQL by myself - before I ran the conversion. And now it worked fine for me.
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
w00t wrote:
Now I wrote the SQL by myself - before I ran the conversion. And now it worked fine for me.
Please, describe what you did. Maybe it will help other users.
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
Thanks to lexazloy and parpalak, however it didn't work for me either.
13 2008-11-15 18:02 (edited by Parpalak 2008-11-15 18:04)
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
snapsolutions wrote:
Thanks to lexazloy and parpalak, however it didn't work for me either.
Well, let's wait for Anatoly's reply (till Monday). It is he who tested and modified the database update script and maybe he will advise something useful.
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
No magic at all. Just convert text/varchar fields like posts & topics to uft_general_ci.
Wrote a small script to automatize all of them and after beeing converted, ran the update script.
Everything now runs smoothly with correct chars.
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
w00t can you please share the script?
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
To all. Please, specify:
1. DB version you had while updating
2. what collations were set on db/tables before update
3. what was the actual encoding of the texts you had in database before update
w00t wrote:
No magic at all. Just convert text/varchar fields like posts & topics to uft_general_ci.
Wrote a small script to automatize all of them and after beeing converted, ran the update script.Everything now runs smoothly with correct chars.
Do you mean setting collation to uft_general_ci at what moment of the update?
db_update.php should have set them while updating.
Carpe diem
17 2008-11-19 21:30 (edited by snapsolutions 2008-11-21 19:05)
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
Anatoly wrote:
To all. Please, specify
1. DB version you had while updating
MySQL 5.0.67
2. what collations were set on db/tables before update
Before the update:
http://www.piccdrop.com/images/1227130147.png
After the update:
http://www.piccdrop.com/images/1227129953.png
3. what was the actual encoding of the texts you had in database before update
windows-1251
- сoordinator
- Junior Member
- Offline
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
19 2008-11-21 19:04 (edited by snapsolutions 2008-11-21 21:47)
Re: Problems with cyrillic after updating from 1.2.20 to 1.3
сoordinator wrote:
Thanks, I'll take a look.