Article View: borland.public.vdbase.data.sql
Article #1063Re: Searching Substrings in BLOB-Fields...
From: Martin T. Thoma
Date: Wed, 20 May 1998 00:00
Date: Wed, 20 May 1998 00:00
32 lines
1651 bytes
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-mailReferences:
<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