🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Searching Substrings in BLOB-Fields...

#1079
From: Martin T. Thoma
Date: Sun, 24 May 1998 00:00
30 lines
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-mail
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>

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