Peter,
1. Have you tried changing the field type to a Blob, even just to try and see if the
effect is the
same.
2. How big is the field. Varchar's over 255 characters in length are treated as
TMemofields
somewhere ( I think it is in the BDE, but cannot be sure - its too early in the
morning for that!! ) .
Good luck.
Kindest Regards
Gary
At 17:51 on 1/02/1999 you wrote
>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
[Reply]
========================================================
Gary Benner - Software Developer [EMAIL PROTECTED]
Corporate Software New Zealand Limited Auckland - New Zealand
tel: +64-9 846-6067 (24hr) fax: +64-9 846-6152 mob: (021)-966-992
Software System Design - Consulting - Mentoring - Data Modelling
Client Server - Delphi - Interbase - Oracle - Web-based Technologies
Electronic Automation and Systems - Microcontroller Design & Software
http://www.corporate.co.nz
Job#: 41006
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz