Received-SPF: neutral (google.com: 75.180.132.120 is neither permitted nor denied by best guess record for domain of phma@bezitopo.org) client-ip=75.180.132.120;
From: Pierre Abbat <phma@bezitopo.org>
To: lojban@googlegroups.com
Subject: Re: [lojban] Re: jboselkei is back
Date: Sun, 17 Nov 2013 19:19:45 -0500
Message-ID: <2189420.Qb1DWKTUXO@caracal>
User-Agent: KMail/4.8.5 (Linux/3.2.0-56-generic; KDE/4.8.5; x86_64; ; )
In-Reply-To: <a53f24ed-39f2-456b-b76f-51bd7fabae52@googlegroups.com>
References: <3534bf0f-d0a8-4b25-a0c8-52945fda2b4b@googlegroups.com> <a53f24ed-39f2-456b-b76f-51bd7fabae52@googlegroups.com>
MIME-Version: 1.0
Reply-To: lojban@googlegroups.com
Precedence: list
Mailing-list: list lojban@googlegroups.com; contact lojban+owners@googlegroups.com
Sender: lojban@googlegroups.com
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset=UTF-8
X-Spam_score: 0.0
X-Spam_score_int: 0
X-Spam_bar: /

On Sunday, November 17, 2013 15:02:38 qx4096@gmail.com wrote:
> Sorry, but it doesn't look like a keyword search will work. From the
> research that I have done, full text indices can only be added to text
> columns and not to blob columns, and the data for the posts and
> translations are blobs not text. When I changed the column from a blob to=
 a
> text on a test database on my local computer, it converted the unicode
> characters to random looking ASCII characters, so I had to change it back=
.

If you take the random-looking characters and run them through iconv, do yo=
u=20
get Unicode? Are they actually ASCII, or do they have accents?

$ iconv -f latin1 -t utf-8
A vonaton egy =C5=91r=C3=BClt, mellette egy =C5=91r =C3=BClt. =C3=96r=C3=BC=
lt az =C5=91r=C3=BClt, hogy mellette egy =C5=91r=20
=C3=BClt.
A vonaton egy =C3=85r=C3=83=C2=BClt, mellette egy =C3=85r =C3=83=C2=BClt. =
=C3=83r=C3=83=C2=BClt az =C3=85r=C3=83=C2=BClt, hogy mellette=20
egy =C3=85r =C3=83=C2=BClt.

The second byte of "=C5=91", 0x91, is invisible because it's a control char=
acter.

(lo fenki cu zvati lo trene .i lo zgaku'i cu mlana ra .i lo fenki cu gleki =
le=20
nu lo zgaku'i cu mlana ra)

mu'omi'e .pier.
--=20
loi mintu se ckaji danlu cu jmaji

--=20
You received this message because you are subscribed to the Google Groups "=
lojban" group.
To unsubscribe from this group and stop receiving emails from it, send an e=
mail to lojban+unsubscribe@googlegroups.com.
To post to this group, send email to lojban@googlegroups.com.
Visit this group at http://groups.google.com/group/lojban.
For more options, visit https://groups.google.com/groups/opt_out.