🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Searching Substrings in BLOB-Fields...

#1063
From: Martin T. Thoma
Date: Wed, 20 May 1998 00:00
32 lines
1651 bytes
Hi Geoff, 

thanks for your answer. With Memos (or Strings), TDBGrid shows only a |
(vertical line) instead of the paragraph �. Blob was the only field to
handle this char � properly. 

Martin

Geoff Wass wrote:
> 
> 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: <3562EBD0.6787@radiok2r.de>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <35629487.4923@radiok2r.de> <3562BE97.A85B46A6@ibm.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: ff5a1,311ffe2432b9f697
X-Google-Attributes: gidff5a1,public
From: "Martin T. Thoma" <martin@radiok2r.de>
Subject: Re: Searching Substrings in BLOB-Fields...
Date: 1998/05/20
Message-ID: <3562EBD0.6787@radiok2r.de>
X-Deja-AN: 354967098
Content-Transfer-Encoding: 8bit
References: <35629487.4923@radiok2r.de> <3562BE97.A85B46A6@ibm.net>
To: Geoff Wass <gswass@ibm.net>
Content-Type: text/plain; charset=iso-8859-1
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql