Subject Re: [IBO] How to store something like the following string with #0s in it
Author Chuck Belanger
So, if anyone is interested. The Firebird support provided the simplest
answer: use a var (char) character set OCTETS.

It works beautifully. No changes to my code. IBOquery (which I am using
because I still use woll2woll components) even provides a VarByte type
to handle it.

Chuck


On 8/3/2018 1:41 PM, Chuck Belanger phytotech@... [IBObjects] wrote:
> Hello:
>
> I have been using a string of '0000's and '11111's to indicate access to
> the underlying position in a database. I have been storing this string
> of '000111' combinations by converting to a set of characters
> representing each 8 "bits" of the actual 0s and 1s.
>
> The problem I am facing is how to store those occasional strings that
> look like this:
>
> 'ΓΌ@'#0'0'#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0
>
> It is not so much all the null characters after the '0', but that null
> character between the '@' and the '0'. The above string is created and
> stored in a string just as you see it, but how do I store it, preferably
> as-is in a table field?
>
> I have tried rawbytestring but that truncates the string at the first #0
> character, thus losing the information in the '0' that follows.
>
> Any thoughts?
>
> Thank you,
>
> Chuck
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
>
> ------------------------------------
> Posted by: Chuck Belanger <phytotech@...>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> http://tracker.ibobjects.com - your portal to submit and monitor bug reports
> http://community.ibobjects.com - your portal to purchase and upgrade
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
>