MySQL Unicode problem with armenian

[Aram Ghazanchyan]

May be this topic was discussed, whatever I have very urgent question concerning armenian text saving into MySQL database. I've tested some texts and still found the following errors on some letters:

1. Armenian "S" is saving as armenian "t"
2. Armenian "c" is saving as "`"

MySQL v. 4.1.10a, PHP 5

Who can help?

and the other question is... I didn't work with armenian texts so much, if I change the mysql version to lower to avoid any collations and encodings and save the data in armscii, can I organize ordering by letters and correct string comparison?

[Forever Child]

Originally Posted by Aram Ghazanchyan

May be this topic was discussed, whatever I have very urgent question concerning armenian text saving into MySQL database. I've tested some texts and still found the following errors on some letters:

1. Armenian "S" is saving as armenian "t"
2. Armenian "c" is saving as "`"

MySQL v. 4.1.10a, PHP 5

Who can help?

and the other question is... I didn't work with armenian texts so much, if I change the mysql version to lower to avoid any collations and encodings and save the data in armscii, can I organize ordering by letters and correct string comparison?

Aram jan, I just tried it with two different conf. Everything works. At home PHP 5.0.4/MySQL 4.1.11. It also works with your litehost hosting. Database encoding 'utf8_general_ci'.

[Aram Ghazanchyan]

It works on lower versions than 4.1, but the ordering is not working there...
I use 4.1.10a, not upgrading to 4.1.11, will see...

[Aram Ghazanchyan]

Sample table dump:
---
CREATE TABLE `sector` (
`ID` int(11) NOT NULL auto_increment,
`Code` varchar(50) collate utf8_bin NOT NULL default '',
`Location` varchar(250) collate utf8_bin NOT NULL default '',
`Tel` varchar(50) collate utf8_bin NOT NULL default '',
UNIQUE KEY `ID` (`ID`),
UNIQUE KEY `Code` (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=16 ;
---

mi.ini file is in attachment

[Aram Ghazanchyan]

Try to insert in armenian unicode
"Cucak" and "Sebastia"

[Forever Child]

I just tried it again and it worked.

Showing rows 0 - 0 (1 total, Query took 0.0003 sec) SQL-query:
SELECT *
FROM `sector`
LIMIT 0 , 30
ID Code Location Tel
1ՑուցակՍեբաստիա666

[Aram Ghazanchyan]

v. of your database is < 4.1