[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-pim
Subject:    Re: [Kde-pim] akonadi, server/storage and PostgreSQl
From:       Kevin Krammer <krammer () kde ! org>
Date:       2013-09-12 9:48:47
Message-ID: 201309121148.51863.krammer () kde ! org
[Download RAW message or body]

[Attachment #2 (multipart/signed)]


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

["signature.asc" (application/pgp-signature)]

_______________________________________________
KDE PIM mailing list kde-pim@kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/

[prev in list] [next in list] [prev in thread] [next in thread]