Article View: borland.public.vdbase.data.sql
Article #988Re: Searching Substrings in BLOB-Fields...
From: Geoff Wass
Date: Mon, 25 May 1998 00:00
Date: Mon, 25 May 1998 00:00
33 lines
1960 bytes
1960 bytes
Martin, It sounds like it /could/ be related to drivers. If you can store it to dBASE tables, then why not experiment by storing it in a dBASE character field and a dBASE memo field. Then, copy the dBASE table to a new Paradox table. If it carries over to the Paradox field, then you will know that Paradox can handle it and that the current Paradox table you are using has the problem. If it does not carry... well, you have more work to do... :-( I tried it on my machine. I am using the American edition, English cp370. I cannot store '�' in the character field (in fact, it corrupts the record!), but I can store it in the memo. When I USE mydbf; COPY TO mydb TYPE PARADOX, the memo field transfers OK. Paradox does not like the '�' in the character field. Like the dbf, the db file will not show '�', but only '' and the record cause an error message. So, you should be able to use MEMOs for '�'s! Good luck. -- 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:
<3568680B.E33F7304@ibm.net>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> <35663161.2C07418C@ibm.net> <35683F20.1DD7@radiok2r.de>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: ff5a1,311ffe2432b9f697 X-Google-Attributes: gidff5a1,public From: Geoff Wass <gswass@ibm.net> Subject: Re: Searching Substrings in BLOB-Fields... Date: 1998/05/25 Message-ID: <3568680B.E33F7304@ibm.net> X-Deja-AN: 356116928 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> <35663161.2C07418C@ibm.net> <35683F20.1DD7@radiok2r.de> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Organization: Noordindarus Consultancy Sdn. Bhd. Newsgroups: borland.public.vdbase.data.sql