Date: Sun, 17 Nov 2013 17:03:50 -0800 (PST)
From: qx4096@gmail.com
To: lojban@googlegroups.com
Message-Id: <e5369b8c-f5d1-430d-90bc-d345b8acc6a5@googlegroups.com>
In-Reply-To: <2189420.Qb1DWKTUXO@caracal>
References: <3534bf0f-d0a8-4b25-a0c8-52945fda2b4b@googlegroups.com> <a53f24ed-39f2-456b-b76f-51bd7fabae52@googlegroups.com>
 <2189420.Qb1DWKTUXO@caracal>
Subject: Re: [lojban] Re: jboselkei is back
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-Type: multipart/alternative; 
	boundary="----=_Part_1510_5599420.1384736630229"
X-Spam_score: -0.1
X-Spam_score_int: 0
X-Spam_bar: /

------=_Part_1510_5599420.1384736630229
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Most of the characters appear as question marks. I tried "$b =3D=20
iconv("UTF-8","ISO-8859-1",$b);" but I got an error saying, "Detected an=20
illegal character in input string".=20

On Sunday, 17 November 2013 16:19:45 UTC-8, Pierre Abbat wrote:
>
> On Sunday, November 17, 2013 15:02:38 qx4...@gmail.com <javascript:>wrote=
:=20
> > Sorry, but it doesn't look like a keyword search will work. From the=20
> > research that I have done, full text indices can only be added to text=
=20
> > columns and not to blob columns, and the data for the posts and=20
> > translations are blobs not text. When I changed the column from a blob=
=20
> to a=20
> > text on a test database on my local computer, it converted the unicode=
=20
> > characters to random looking ASCII characters, so I had to change it=20
> back.=20
>
> If you take the random-looking characters and run them through iconv, do=
=20
> you=20
> get Unicode? Are they actually ASCII, or do they have accents?=20
>
> $ iconv -f latin1 -t utf-8=20
> A vonaton egy =C5=91r=C3=BClt, mellette egy =C5=91r =C3=BClt. =C3=96r=C3=
=BClt az =C5=91r=C3=BClt, hogy mellette=20
> egy =C5=91r=20
> =C3=BClt.=20
> 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=20
> mellette=20
> egy =C3=85r =C3=83=C2=BClt.=20
>
> The second byte of "=C5=91", 0x91, is invisible because it's a control=20
> character.=20
>
> (lo fenki cu zvati lo trene .i lo zgaku'i cu mlana ra .i lo fenki cu glek=
i=20
> le=20
> nu lo zgaku'i cu mlana ra)=20
>
> mu'omi'e .pier.=20
> --=20
> loi mintu se ckaji danlu cu jmaji=20
>
>

--=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.

------=_Part_1510_5599420.1384736630229
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Most of the characters appear as question marks. I tried "=
$b =3D iconv("UTF-8","ISO-8859-1",$b);" but I got an error saying, <font si=
ze=3D"2">"Detected an illegal character in input string"</font>. <br><br>On=
 Sunday, 17 November 2013 16:19:45 UTC-8, Pierre Abbat  wrote:<blockquote c=
lass=3D"gmail_quote" style=3D"margin: 0;margin-left: 0.8ex;border-left: 1px=
 #ccc solid;padding-left: 1ex;">On Sunday, November 17, 2013 15:02:38 <a hr=
ef=3D"javascript:" target=3D"_blank" gdf-obfuscated-mailto=3D"N5anlJcWu94J"=
>qx4...@gmail.com</a> wrote:
<br>&gt; Sorry, but it doesn't look like a keyword search will work. From t=
he
<br>&gt; research that I have done, full text indices can only be added to =
text
<br>&gt; columns and not to blob columns, and the data for the posts and
<br>&gt; translations are blobs not text. When I changed the column from a =
blob to a
<br>&gt; text on a test database on my local computer, it converted the uni=
code
<br>&gt; characters to random looking ASCII characters, so I had to change =
it back.
<br>
<br>If you take the random-looking characters and run them through iconv, d=
o you=20
<br>get Unicode? Are they actually ASCII, or do they have accents?
<br>
<br>$ iconv -f latin1 -t utf-8
<br>A vonaton egy =C5=91r=C3=BClt, mellette egy =C5=91r =C3=BClt. =C3=96r=
=C3=BClt az =C5=91r=C3=BClt, hogy mellette egy =C5=91r=20
<br>=C3=BClt.
<br>A vonaton egy =C3=85r=C3=83=C2=BClt, mellette egy =C3=85r =C3=83=C2=BCl=
t. =C3=83r=C3=83=C2=BClt az =C3=85r=C3=83=C2=BClt, hogy mellette=20
<br>egy =C3=85r =C3=83=C2=BClt.
<br>
<br>The second byte of "=C5=91", 0x91, is invisible because it's a control =
character.
<br>
<br>(lo fenki cu zvati lo trene .i lo zgaku'i cu mlana ra .i lo fenki cu gl=
eki le=20
<br>nu lo zgaku'i cu mlana ra)
<br>
<br>mu'omi'e .pier.
<br>--=20
<br>loi mintu se ckaji danlu cu jmaji
<br>
<br></blockquote></div>

<p></p>

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

------=_Part_1510_5599420.1384736630229--