Bug 237676

Summary: Accents are not displayed properly in new folder names
Product: [Applications] kmail2 Reporter: Sabine Faure <sabine>
Component: generalAssignee: kdepim bugs <kdepim-bugs>
Status: RESOLVED FIXED    
Severity: normal CC: mail, marcello, montel, vkrause
Priority: HI Keywords: akonadi-ports-regression
Version: unspecified   
Target Milestone: ---   
Platform: Compiled Sources   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Bug Depends on:    
Bug Blocks: 223438    
Attachments: Folder names containing accents are not displayed properly in Folder view
Akonadi console snapshot
result from charsetdebug.sql
My dump.txt

Description Sabine Faure 2010-05-14 23:20:32 UTC
Version:            (using Devel)
Compiler:          gcc 4.3.2 
OS:                Linux
Installed from:    Compiled sources

- Launch Kmail
- Right click on Local Folders and select 'New Folder...'
- Enter a folder name containing accents (ex: récréation)
- Click on 'Ok' the button

The folder is displayed in the Folder View but instead of the accents, '?' are displayed.

Trunk, Svn Rev 1126573
Comment 1 Laurent Montel 2010-05-16 14:26:12 UTC
Work fine here svn #1127374
Comment 2 Thomas McGuire 2010-05-17 00:21:43 UTC
I can't reproduce this either.
Comment 3 Milian Wolff 2010-05-20 18:29:03 UTC
please update and try again, I hope to have fixed it now.
Comment 4 Sabine Faure 2010-05-21 00:21:39 UTC
I retested this today and I still have the bug so I am reopening this report.

See snapshot enclosed for details.

Trunk, Svn Rev 1128989
Comment 5 Sabine Faure 2010-05-21 00:30:25 UTC
Created attachment 43764 [details]
Folder names containing accents are not displayed properly in Folder view

I tested this after updating and then starting Akonadi server and I still have the bug as you can see in the attachment enclosed.

I have it both when creating folders in the Local Folders and an Imap resource.

Trunk, Svn Rev 1128989
Comment 6 Milian Wolff 2010-05-21 01:28:43 UTC
Hello Sabine,

sadly I cannot reproduce which means you'll have to help me debug it :)

Please put the following lines into a file called e.g. charsetdebug.sql:

show variables like 'character_set%';
select '--------';
show create database akonadi;
select '--------';
show create table collectiontable;
select '--------';
select name from collectiontable;

Now, while akonadi is running, please execute the following command:

mysql -S ~/.local/share/akonadi/db_misc/mysql.socket akonadi < charsetdebug.sql > dump.txt

And attach the generated file.

Thank you, good night.
Comment 7 Milian Wolff 2010-05-21 12:01:20 UTC
Small change, please put these queries into charsetdebug.sql instead:

set names utf8;
show variables like 'character_set%';
select '--------';
show create database akonadi;
select '--------';
show create table collectiontable;
select '--------';
select name from collectiontable;

And run them with the command above. Additionally, please run this query in akonadiconsole's DB Console tab (put it into the lower text edit and press the button to the right, then screenshot the result or something like that):

show variables like 'character_set%';
Comment 8 Sabine Faure 2010-05-21 21:42:21 UTC
Created attachment 43786 [details]
Akonadi console snapshot

Trunk, Svn Rev 1129177
Comment 9 Sabine Faure 2010-05-21 21:44:50 UTC
Created attachment 43787 [details]
result from charsetdebug.sql

Hi Milian!

You will find the information you asked me for enclosed here and above.
I hope this helps ;o)

Trunk, Svn Rev 1129177
Comment 10 Thomas McGuire 2010-06-29 14:48:08 UTC
Created attachment 48456 [details]
My dump.txt
Comment 11 Thomas McGuire 2010-06-29 14:51:06 UTC
Debug output from akonadiconsole:

akonadiconsole-1182112391 (0x74abe0) 2 CREATE "Töst" 4 ( REMOTEID "" REMOTEREVISION "" CACHEPOLICY (INHERIT true)) 
akonadiconsole-1182112391 (0x74abe0) * 15 4 (NAME "Töst" MIMETYPE (message/rfc822 inode/directory) REMOTEID "" REMOTEREVISION "" RESOURCE "akonadi_maildir_resource_0" CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT 1 SYNCONDEMAND true LOCALPARTS (HEAD)) ) 
akonadiconsole-1182112391 (0x74abe0) 2 OK CREATE completed 
akonadi_maildir_resource_0 (0x7f41a0013320) 23 LSUB 15 0 () (ANCESTORS INF) 
akonadi_maildir_resource_0 (0x7f41a0013320) * 15 4 (NAME "Töst" MIMETYPE (message/rfc822 inode/directory) REMOTEID "" REMOTEREVISION "" RESOURCE "akonadi_maildir_resource_0" CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT 1 SYNCONDEMAND true LOCALPARTS (HEAD)) ANCESTORS ((4 "/media/kdedev/kde45/.local/share/local-mail") (0 "")) ) 
akonadi_maildir_resource_0 (0x7f41a0013320) 23 OK List completed 
akonadi_maildir_resource_0 (0x7f41a0013320) 24 UID MODIFY 15 PARENT 4 NAME "Töst" REMOTEID "Töst" REMOTEREVISION "" 
akonadi_maildir_resource_0 (0x7f41a0013320) 24 OK MODIFY done 
AkonadiConsole Browser Widget (0x72baa0) 21 LSUB 15 0 () (ANCESTORS INF) 
AkonadiConsole Browser Widget (0x72baa0) * 15 4 (NAME "Töst" MIMETYPE (message/rfc822 inode/directory) REMOTEID "Töst" REMOTEREVISION "" RESOURCE "akonadi_maildir_resource_0" CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT 1 SYNCONDEMAND true LOCALPARTS (HEAD)) ANCESTORS ((4 "/media/kdedev/kde45/.local/share/local-mail") (0 "")) ) 
AkonadiConsole Browser Widget (0x72baa0) 21 OK List completed 
AkonadiConsole Browser Widget (0x72baa0) 22 LSUB 15 0 () (ANCESTORS INF) 
AkonadiConsole Browser Widget (0x72baa0) * 15 4 (NAME "Töst" MIMETYPE (message/rfc822 inode/directory) REMOTEID "Töst" REMOTEREVISION "" RESOURCE "akonadi_maildir_resource_0" CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT 1 SYNCONDEMAND true LOCALPARTS (HEAD)) ANCESTORS ((4 "/media/kdedev/kde45/.local/share/local-mail") (0 "")) ) 
AkonadiConsole Browser Widget (0x72baa0) 22 OK List completed
Comment 12 Thomas McGuire 2010-07-06 09:35:29 UTC
Milian started looking at this yesterday, apparently a Qt mysql plugin bug.
Comment 13 Thomas McGuire 2010-07-06 09:35:48 UTC
*** Bug 243411 has been marked as a duplicate of this bug. ***
Comment 14 Volker Krause 2010-08-02 08:53:13 UTC
Should be fixed with Akonadi server >= 1.4.0.