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

[Kevin Krammer]

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.

Cheers,
Kevin
-- 
Kevin Krammer, KDE developer, xdg-utils developer
KDE user support, developer mentoring
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 190 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20130912/743139d7/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/