In any case, that patch isn't the LJ issue, because LJ doesn't use SQLite. So our problem is elsewhere.<div><br></div><div>Also, that patch seems like it might not be entirely robust: when did that unicode field get added to $dbh? Does it work on all DBD::SQLite versions, or just as of a certain point? Plus, I'm not sure that's the proper fix: marking all scalars from the database as SvUTF8? Is the rest of djabberd fully SvUTF8 or do we do UTF8-in-bytes without SvUTF8?</div>
<div><br><div class="gmail_quote">On Mon, Dec 15, 2008 at 2:21 PM, Michael Scherer <span dir="ltr"><<a href="mailto:misc@mandriva.org">misc@mandriva.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
Le 15 déc. 08 à 19:58, Martin Atkins a écrit :<div class="Ih2E3d"><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
I remember a bug of this nature in the SQLite vCard backend being discussed a long time ago. Something to do with how the SQLite module handles UTF-8.<br>
<br>
I thought it'd been fixed, but I can't find anything in the (pretty short) revision history for the vCard plugin. Maybe there's a patch somewhere in the archive of this mailing list that didn't get committed?<br>
</blockquote>
<br></div>
you mean this one :<br>
<a href="http://lists.danga.com/pipermail/djabberd/2007-September/000401.html" target="_blank">http://lists.danga.com/pipermail/djabberd/2007-September/000401.html</a><br>
<br>
I have resent a email on septembre 2008 to ask to be included again :)<br>
<br>
-- <br><font color="#888888">
Michael Scherer</font></blockquote></div><br></div>