Received: from mail-qa0-f64.google.com ([209.85.216.64]:52223) by stodi.digitalkingdom.org with esmtps (TLSv1:RC4-SHA:128) (Exim 4.80.1) (envelope-from ) id 1ViBMd-00022T-Ks for lojban-list-archive@lojban.org; Sun, 17 Nov 2013 15:02:53 -0800 Received: by mail-qa0-f64.google.com with SMTP id cm18sf681519qab.29 for ; Sun, 17 Nov 2013 15:02:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=20120806; h=date:from:to:cc:message-id:in-reply-to:references:subject :mime-version:x-original-sender:reply-to:precedence:mailing-list :list-id:list-post:list-help:list-archive:sender:list-subscribe :list-unsubscribe:content-type; bh=e2xpQ8oi8PIGjzLpmFi8ErufC7TTCsuMj6lRdlSEk+c=; b=kaG7G0HFMH140PAc/PybiHhihvsOIehOZpQdXKvKwDU5H32cc8VqXzj0ket3gPlkl/ dTsSO+UeDkW3PRYoII3SWgU6FVgkiXmL5xTYDw+N8yRUDXf0hNj0F79SNnwDPbvXZIlZ CPgUfd1fLoPzFQWb7jo21kTzIF70ETvjYaWdmDcKQITvWQciLBR/IrCrxt6oZVvqvEQP bSlpvsmHfXdsBZTmg/w2wJiufPFo1rMsUdlYdGhBJ0O3po0Kls4fiEurVW0Xgmb3qRQY yKM7PtzJwgxBUSjiYtQuMsFWR9s++FmB1jsDCKCacTSphaDoTbOfwyrScpWJzQKwacTL 0bQg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=date:from:to:cc:message-id:in-reply-to:references:subject :mime-version:x-original-sender:reply-to:precedence:mailing-list :list-id:list-post:list-help:list-archive:sender:list-subscribe :list-unsubscribe:content-type; bh=e2xpQ8oi8PIGjzLpmFi8ErufC7TTCsuMj6lRdlSEk+c=; b=v/u/FDAcNKcNE79zsDYG9+uq88gJBNrkNNuhXa1auExxz09EOxJ+zE8mjv13rBpndZ Zz3GDZcwbxewvTafBkl8Bnwc/2quJrFCt3PGzruPQ56EfltHYJdu3tjLrt9+cH87WNs/ SyTdX+LCQura2qUOB/Bu6lisZD9u4qSeNfNgYigb7nY29XmGY/Hcj/geJoX6r9XaYsjT PrqQvUoJE7ig21Cxkn7/2gMWDOvverNuUY9+ug8klNxP3H8nUlnD/YRtDbnW/ys59mwg xxvSbKBIpgNTKXQ9BWGdjBWc5jSURYx0PPOXjCJI9uFMwvKYklQRIRDyefzvR9A5RsGN +SoQ== X-Received: by 10.50.171.169 with SMTP id av9mr293290igc.11.1384729360249; Sun, 17 Nov 2013 15:02:40 -0800 (PST) X-BeenThere: lojban@googlegroups.com Received: by 10.50.36.7 with SMTP id m7ls1422464igj.21.gmail; Sun, 17 Nov 2013 15:02:39 -0800 (PST) X-Received: by 10.50.79.133 with SMTP id j5mr292784igx.2.1384729359646; Sun, 17 Nov 2013 15:02:39 -0800 (PST) Date: Sun, 17 Nov 2013 15:02:38 -0800 (PST) From: qx4096@gmail.com To: lojban@googlegroups.com Cc: qx4096@gmail.com Message-Id: In-Reply-To: <3534bf0f-d0a8-4b25-a0c8-52945fda2b4b@googlegroups.com> References: <3534bf0f-d0a8-4b25-a0c8-52945fda2b4b@googlegroups.com> Subject: [lojban] Re: jboselkei is back MIME-Version: 1.0 X-Original-Sender: qx4096@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="----=_Part_1389_2248950.1384729358564" X-Spam-Score: -0.1 (/) X-Spam_score: -0.1 X-Spam_score_int: 0 X-Spam_bar: / ------=_Part_1389_2248950.1384729358564 Content-Type: text/plain; charset=ISO-8859-1 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. ------=_Part_1389_2248950.1384729358564 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
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 t= o text columns and not to blob columns, and the data for the posts and tran= slations are blobs not text. When I changed the column from a blob to a tex= t on a test database on my local computer, it converted the unicode charact= ers 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.
------=_Part_1389_2248950.1384729358564--