I can't help directly but you might wanna do a quick test with FreeIB Comps
and compare the results. Another thought, does the field ever contain a
char(0)? Can you make it a text blob? Is the field char or varchar?
Tried a different BDE?
"Peter Hyde" <[EMAIL PROTECTED]> on 01/02/99 22:42:04
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
cc: (bcc: Peter Jones/Logistics&Information
Technology/Christchurch/Foodstuffs)
Subject: [DUG]: Interbase field data oddity
Hi folks,
I have an Interbase database containing a string field which is
effecitvely binary (i.e. potentially uses any of the 255 "ASCII"
characters, not just the usual 127 or so text ones).
My application is accessing the field both via the BDE/SQL Links
*and* via IBObjects. Via the latter, the data from this field is
always returned ok. Via SQL links, high-bit characters are getting
munged (to other high-bit characters -- can't spot the exact
pattern, but an example is that chr(174) is returned as chr(171)).
Naturally, I've checked the BDE administrator's Language Driver
selection for that alias, and it is blank. Any idea what I should set
it to to prevent this behaviour? Or perhaps one of the driver flags
or some such?
(No, I don't really have the option of using IBObjects only -- some
other components are dependent on the BDE-based ones, alas,
so they are used in this very specific case. Ugh.)
cheers,
peter
==================================================
Peter Hyde, SPIS Ltd, Christchurch, New Zealand
* TurboNote: http://TurboPress.com/tbnote.htm
-- small, FREE and very handy
* Print-to-Web automation http://TurboPress.com
* Web design, automation and hosting specialists
Find all the above and MORE at http://www.spis.co.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
