Bug 237676 - Accents are not displayed properly in new folder names
Summary: Accents are not displayed properly in new folder names
Status: RESOLVED FIXED
Alias: None
Product: kmail2
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Compiled Sources Linux
: HI normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords: akonadi-ports-regression
: 243411 (view as bug list)
Depends on:
Blocks: 223438
  Show dependency treegraph
 
Reported: 2010-05-14 23:20 UTC by Sabine Faure
Modified: 2010-08-02 08:53 UTC (History)
4 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
Folder names containing accents are not displayed properly in Folder view (40.59 KB, image/jpeg)
2010-05-21 00:30 UTC, Sabine Faure
Details
Akonadi console snapshot (74.74 KB, image/jpeg)
2010-05-21 21:42 UTC, Sabine Faure
Details
result from charsetdebug.sql (4.61 KB, text/plain)
2010-05-21 21:44 UTC, Sabine Faure
Details
My dump.txt (1.36 KB, text/plain)
2010-06-29 14:48 UTC, Thomas McGuire
Details

Note You need to log in before you can comment on or make changes to this bug.
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.