Received: from mail-pa0-f57.google.com ([209.85.220.57]:46547) by stodi.digitalkingdom.org with esmtps (TLSv1:RC4-SHA:128) (Exim 4.80.1) (envelope-from ) id 1ViBwv-00028W-Ve for lojban-list-archive@lojban.org; Sun, 17 Nov 2013 15:40:22 -0800 Received: by mail-pa0-f57.google.com with SMTP id kl14sf235417pab.2 for ; Sun, 17 Nov 2013 15:40:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=20120806; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :x-original-sender:x-original-authentication-results:reply-to :precedence:mailing-list:list-id:list-post:list-help:list-archive :sender:list-subscribe:list-unsubscribe:content-type; bh=WiKXC7rglHLA9UFMys4eLcJ24OwVpE6kDlkvsw8BRb0=; b=wp0ziKcs4b3MEcBDFTRwbp6t5b4BwQR+8tZFmSvfr7xoIsy3HQRJEvgBRhInzsXt4J tOBApVBdlbXyT5mDxFVUr5TYXoWM6So30FX85zmfuT5qibvjIiOFaTRrJM9qW2ar3U/w ee03AS8ivMx03MOijFZHrZaqi4XTWg1W+2ViSCyhmVOJs+2qH0oL3P/Ef5dL2FeufKFV G5+WNPxG1ctvGZ7hAH6Wof7bZl0dnLysmqlNYnqceVaMqqyfrxB7U2GsPFlpQgkd+vF3 71hNCpLb9QF10P9Dp5aIRMmX85tx5WMBKnHWM/mnaJWsdH3syUFeXrTZDS/ZA79unlMO B8MQ== X-Received: by 10.182.53.193 with SMTP id d1mr171004obp.0.1384731610800; Sun, 17 Nov 2013 15:40:10 -0800 (PST) X-BeenThere: lojban@googlegroups.com Received: by 10.182.240.193 with SMTP id wc1ls1452563obc.74.gmail; Sun, 17 Nov 2013 15:40:09 -0800 (PST) X-Received: by 10.182.230.168 with SMTP id sz8mr7044489obc.9.1384731609634; Sun, 17 Nov 2013 15:40:09 -0800 (PST) Received: from mail-qc0-x236.google.com (mail-qc0-x236.google.com [2607:f8b0:400d:c01::236]) by gmr-mx.google.com with ESMTPS id b6si3221979qcn.1.2013.11.17.15.40.09 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Sun, 17 Nov 2013 15:40:09 -0800 (PST) Received-SPF: pass (google.com: domain of eyeonus@gmail.com designates 2607:f8b0:400d:c01::236 as permitted sender) client-ip=2607:f8b0:400d:c01::236; Received: by mail-qc0-f182.google.com with SMTP id n7so3411143qcx.41 for ; Sun, 17 Nov 2013 15:40:09 -0800 (PST) MIME-Version: 1.0 X-Received: by 10.49.103.161 with SMTP id fx1mr29490777qeb.68.1384731609529; Sun, 17 Nov 2013 15:40:09 -0800 (PST) Received: by 10.96.224.5 with HTTP; Sun, 17 Nov 2013 15:40:09 -0800 (PST) In-Reply-To: References: <3534bf0f-d0a8-4b25-a0c8-52945fda2b4b@googlegroups.com> Date: Sun, 17 Nov 2013 16:40:09 -0700 Message-ID: Subject: Re: [lojban] Re: jboselkei is back From: Jonathan Jones To: lojban@googlegroups.com X-Original-Sender: eyeonus@gmail.com X-Original-Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of eyeonus@gmail.com designates 2607:f8b0:400d:c01::236 as permitted sender) smtp.mail=eyeonus@gmail.com; dkim=pass header.i=@gmail.com; dmarc=pass (p=NONE dis=NONE) header.from=gmail.com Reply-To: lojban@googlegroups.com Precedence: list Mailing-list: list lojban@googlegroups.com; contact lojban+owners@googlegroups.com List-ID: X-Google-Group-Id: 1004133512417 List-Post: , List-Help: , List-Archive: Sender: lojban@googlegroups.com List-Subscribe: , List-Unsubscribe: , Content-Type: multipart/alternative; boundary=047d7b2e466ab2096c04eb67f337 X-Spam-Score: 0.0 (/) X-Spam_score: 0.0 X-Spam_score_int: 0 X-Spam_bar: / --047d7b2e466ab2096c04eb67f337 Content-Type: text/plain; charset=ISO-8859-1 I'm willing to bet there is a *nix script that can fix that, but I don't personally know what it is. On Sun, Nov 17, 2013 at 4:02 PM, 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. > > -- > 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 > email 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. > -- mu'o mi'e .aionys. .i.e'ucai ko cmima lo pilno be denpa bu .i doi.luk. mi patfu do zo'o (Come to the Dot Side! Luke, I am your father. :D ) -- 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 email 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. --047d7b2e466ab2096c04eb67f337 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
I'm willing to bet there is a *nix script that can fix= that, but I don't personally know what it is.


On Sun, Nov 17, 2013 at 4:02= PM, <qx4096@gmail.com> wrote:
Sorry, but it doesn't l= ook like a keyword search will work. From the research that I have done, fu= ll 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 chan= ged the column from a blob to a text on a test database on my local compute= r, it converted the unicode characters to random looking ASCII characters, = so I had to change it back.

--
You received this message because you are subscribed to the Google Groups &= quot;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.



--
mu'o mi= 'e .aionys.

.i.e'ucai ko cmima lo pilno be denpa bu .i doi.l= uk. mi patfu do zo'o
(Come to the Dot Side! Luke, I am your father. = :D )

--
You received this message because you are subscribed to the Google Groups &= quot;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.
--047d7b2e466ab2096c04eb67f337--