[Kde-pim] Review Request: fix collation and charsets in mysql database

[Milian Wolff]

Bertjan Broeksema, 03.05.2010:
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> http://reviewboard.kde.org/r/3877/#review5377
> -----------------------------------------------------------
> 
> 
> 
> /trunk/kdesupport/akonadi/server/src/storage/dbupdate.xml
> <http://reviewboard.kde.org/r/3877/#comment5086>
> 
>     These look indeed mysql specific. I had a quick look at the sqlite
> website but it isn't immediately clear to me how to solve this. I think
> you need to do it programmatic partly.
> 
>     Have a look here:
> 
>     http://www.sqlite.org/datatype3.html#collation
> 
>     and here:
> 
>     http://www.sqlite.org/c3ref/create_collation.html

Well, according to these and esp. to this small IRC conversation in #sqlite:

<milian> has sqlite any notion of a 'default charset' for a table? or how 
should that be handled?
<milian> or is utf8 the default anyways?
<alexises> utf8 is the default charset but it exist another set of function to 
use utf16
<ln-> as far as i understand, sqlite assumes you use utf8... but if you use 
something else, it'll be stored as something else.  (i.e. there is no 
automatic conversion to utf8)
<Chunky_Ks> sqlite pretty much stores what you tell it. And the only two 
functions for telling it are either utf8 or utf16, at least for now
<Chunky_Ks> IF youi want something else, you might find blobs more effective or 
something like

I'd say this is a non-issue for SQLite since all code in contact with the DB 
in akonadi use ::fromUtf8 / toUtf8 as far as I can see. So I'd say we fix this 
for MySQL and don't care about the other DBs until proved otherwise?

Bye
-- 
Milian Wolff
mail at milianw.de
http://milianw.de
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20100503/16a54818/attachment.sig>
-------------- next part --------------
_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/