🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #1062

Re: Searching Substrings in BLOB-Fields...

#1062
From: Geoff Wass
Date: Wed, 20 May 1998 00:00
25 lines
1321 bytes
Martin,

I /think/ that if you stick to BLOBs, then you will have to read each
blob first into a string (for example) and search that. This means, you
would have to do the looping and not use SQL.

I have not tried using unusual characters in memo fields. I would think
there should be no problem as long as you are not including unprintable
characters that might like like a marker for "end of memo" or the like.
Have you tried memos? What happened?


--
Geoff Wass
Kuala Lumpur, Malaysia


=============================================================
Please respond to a newsgroup posting by posting a reply (not e-mail).
In this way, all can help and all can learn!


=============================================================
Triumph is in the first syllable.
Technical Details
Message-ID: <3562BE97.A85B46A6@ibm.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <35629487.4923@radiok2r.de>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,311ffe2432b9f697,start
X-Google-Attributes: gidff5a1,public
From: Geoff Wass <gswass@ibm.net>
Subject: Re: Searching Substrings in BLOB-Fields...
Date: 1998/05/20
Message-ID: <3562BE97.A85B46A6@ibm.net>
X-Deja-AN: 354921208
Content-Transfer-Encoding: 7bit
References: <35629487.4923@radiok2r.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Noordindarus Consultancy Sdn. Bhd.
Newsgroups: borland.public.vdbase.data.sql