> On Tue, 2006-06-06 at 11:30 +0400, Oleg Lapshin wrote: > > > Hello > > > > > > I download and run svn-2154 revision (after 2139) > > > > > > And I can't read all my mailboxes! > > > Some `selects` (from dbmail-logs and my own): > > > > I found my error: > > the `name` field in database was varbinary(100) type > > I dont' know why. > > It's how the column is defined in dbmail/sql/mysql/create_tables.mysql: > > name varchar(100) BINARY NOT NULL default '',
Yes, I take my look at create_tables.mysql and correct field definition in my database. > I'm not sure yet how to work around the case sensitivity issue of the > mailboxes. We need a smart way to get US-ASCII to lowercase itself while > preserving the case of the US-ASCII that is between & - pairs. > > I'm sure you'll notice that any mailboxes with Russian characters are > completely broken... in fact, could you create a mailbox with some > Russian characters and post their rows from the database? I attach mysqldump of dbmail_mailboxes with russian folders. kmail created this folders as 'organizer folders' and I see they in russian. They are: Organizer/Дневник Organizer/Задачи Organizer/Заметки Organizer/Календарь Organizer/Контакты or in english: Organizer/Diary Organizer/Tasks Organizer/Notes Organizer/Calendar Organizer/Contacts also, I create my folder Тест/ (Test in english) -- Oleg Lapshin
-- MySQL dump 10.10 -- -- Host: localhost Database: dbmail -- ------------------------------------------------------ -- Server version 5.0.22 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES koi8r */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `dbmail_mailboxes` -- DROP TABLE IF EXISTS `dbmail_mailboxes`; CREATE TABLE `dbmail_mailboxes` ( `mailbox_idnr` bigint(21) NOT NULL auto_increment, `owner_idnr` bigint(21) NOT NULL default '0', `name` varchar(100) character set koi8r collate koi8r_bin NOT NULL default '', `seen_flag` tinyint(1) NOT NULL default '0', `answered_flag` tinyint(1) NOT NULL default '0', `deleted_flag` tinyint(1) NOT NULL default '0', `flagged_flag` tinyint(1) NOT NULL default '0', `recent_flag` tinyint(1) NOT NULL default '0', `draft_flag` tinyint(1) NOT NULL default '0', `no_inferiors` tinyint(1) NOT NULL default '0', `no_select` tinyint(1) NOT NULL default '0', `permission` tinyint(1) default '2', PRIMARY KEY (`mailbox_idnr`), KEY `name_index` (`name`), KEY `owner_idnr_index` (`owner_idnr`), KEY `owner_idnr_name_index` (`owner_idnr`,`name`), CONSTRAINT `0_16` FOREIGN KEY (`owner_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=koi8r; -- -- Dumping data for table `dbmail_mailboxes` -- /*!40000 ALTER TABLE `dbmail_mailboxes` DISABLE KEYS */; LOCK TABLES `dbmail_mailboxes` WRITE; INSERT INTO `dbmail_mailboxes` VALUES (1,2,'INBOX',1,1,1,1,1,1,0,0,2),(2,1,'INBOX',1,1,1,1,1,1,0,0,2),(3,2,'SENT',1,1,1,1,1,1,0,0,2),(14,3,'INBOX',1,1,1,1,1,1,0,0,2),(15,2,'Trash',1,1,1,1,1,1,0,0,2),(16,2,'Sent1',1,1,1,1,1,1,0,0,2),(18,2,'SPAM',1,1,1,1,1,1,0,0,2),(63,2,'0rganizer',1,1,1,1,1,1,0,0,2),(64,2,'0rganizer/&BBoEMAQ7BDUEPQQ0BDAEQARM-',1,1,1,1,1,1,0,0,2),(65,2,'0rganizer/&BBcEMAQ0BDAERwQ4-',1,1,1,1,1,1,0,0,2),(66,2,'0rganizer/&BBQEPQQ1BDIEPQQ4BDo-',1,1,1,1,1,1,0,0,2),(67,2,'0rganizer/&BBoEPgQ9BEIEMAQ6BEIESw-',1,1,1,1,1,1,0,0,2),(68,2,'0rganizer/&BBcEMAQ8BDUEQgQ6BDg-',1,1,1,1,1,1,0,0,2),(71,2,'&BCIENQRBBEI-',1,1,1,1,1,1,0,0,2); UNLOCK TABLES; /*!40000 ALTER TABLE `dbmail_mailboxes` ENABLE KEYS */; /*!40103 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40111 SET [EMAIL PROTECTED] */;