Article View: borland.public.vdbase.data.sql
Article #1079Re: Searching Substrings in BLOB-Fields...
From: Martin T. Thoma
Date: Sun, 24 May 1998 00:00
Date: Sun, 24 May 1998 00:00
30 lines
1739 bytes
1739 bytes
Steve Koterski wrote: > > On Fri, 22 May 1998 19:36:59 +0200, "Martin T. Thoma" <martin@radiok2r.de> > wrote: > > >no it a Control from BCBuilder 3.0. But I thought it was a SQP Problem, > >because when I did the query, there was an error in the SQL-statement > >(because you can't search BLOBs with SQL). > > A bit of clarification on that. > > The ability to filter in an SQL statement based on the contents of a memo > column is implementation-specific. Some database systems will allow it, > others not, and still others partially with limitations. > Hi Steve, I don't know if you got the right point. My problem was, that I needed to use the char '�' in a local Paradox-Database. But this char is only supported in BLOBs. So I used Blobs. But then, I wanted to do a SQL-Query with "LIKE" on these BLOBs and this didn't work. Now I've got 2 posibilities: 1.) Not using SQL 2.) Using a Memo and replacing the char '�' with another. Is this right or did I forgot something ?? Martin
Technical Details
Message-ID:
<35683E7B.3FA5@radiok2r.de>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35629487.4923@radiok2r.de> <3562BE97.A85B46A6@ibm.net> <3562EBD0.6787@radiok2r.de> <3563AEDF.887C119B@ibm.net> <3565B7BB.6346@radiok2r.de> <3566e084.19372778@forums.inprise.com>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/24 Message-ID: <35683E7B.3FA5@radiok2r.de> X-Deja-AN: 356078288 Content-Transfer-Encoding: 8bit References: <35629487.4923@radiok2r.de> <3562BE97.A85B46A6@ibm.net> <3562EBD0.6787@radiok2r.de> <3563AEDF.887C119B@ibm.net> <3565B7BB.6346@radiok2r.de> <3566e084.19372778@forums.inprise.com> Mime-Version: 1.0 To: koterski@borland.com Content-Type: text/plain; charset=iso-8859-1 Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql