[Kde-pim] akonadi, server/storage and PostgreSQl

[Cédric Villemain]

Le jeudi 12 septembre 2013 11:48:47 Kevin Krammer a écrit :
> On Thursday, 2013-09-12, Cédric Villemain wrote:
> > > > Akonadi maps QString to BYTEA (PostgreSQL data type), I believe
> > > > it
> > > > should map it to TEXT. 1. we do use toLatin1 to prepare data
> > > > when
> > > > working with QString, so it should be safe for TEXT in
> > > > PostgreSQL.
> > > > 2. escaping BYTEA and TEXT does not work the same, BYTEA are
> > > > escaped string *or* hex string. TEXT is plain, or escaped.
> > > 
> > > We would need to check what kind of data is stored in BYTEA, but
> > > QString itself is UTF8. Does TEXT support utf8 (sorry, no time to
> > > look this up now)?
> > 
> > Yes, it does.
> 
> Just for the record: QString uses a 16bit encoding interally (UTF_16 I
> think) but it can convert from/to UTF-8.

important record!
How does it works for UTF16 users currently, Is akonadi UTF16 
compliant ?

I've seen some .toLatin1() (LATIN1 is also an encoding supported by 
PostgreSQL) so I supposed that the strings are all converted to latin1 
(in akonadi). However, there are also some conversion to UTF8...

-- 
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20130912/98c02530/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/