Searching Substrings in BLOB-Fields...

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

Article #1066

Back to borland.public.vdbase.data.sql Previous Next

#1066

From: Martin T. Thoma
Date: Wed, 20 May 1998 00:00

16 lines
1040 bytes

Hi !

I got the following problem: I want to store textes longer then 254
Chars in a Paradox-Database. Because the text contains some special
chars (like �), I used Blob-Fields instead of Memo-Fields. How can I
execute a query on these Blob fields to find substrings ? With the
Memo-Fields, it looks like "SELECT * FROM Database WHERE Field LIKE
"%substring%"", but this doesn't work on Blob fields. Any ideas how to
do the query or how to use Memo-Fields with the char '�' ?

Greetings

Martin

P.S.: Please EMail your answer, too.

Technical Details

Message-ID: <35629487.4923@radiok2r.de>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

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: Searching Substrings in BLOB-Fields...
Date: 1998/05/20
Message-ID: <35629487.4923@radiok2r.de>
X-Deja-AN: 354889170
Content-Transfer-Encoding: 8bit
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql