INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Problem getting data from a string field storing Binary data

Problem getting data from a string field storing Binary data

(OP)
I am trying to query a field in an older (7.x I believe) SQLBase DB that appears to be storing large amounts of text as null character separated ASCII hex pairs such as the one below:

4100700070006500610072007300200074006F00200062006500200061006E0020006F006C00640020007000610072007400

It seems to be good data I was able to convert this field using a c# encoding function and only reading every other pair to get around the 00 NULL characters this one works out to: "Appears to be an old part"

I am running a query that selects this field for a particular row in C# using the SQLBASEOLEDB.1 provider. However it returns only the first character and then seems to be stopped by the null character so all I get in the case of the above field is "A".

Does anyone know how to get it to ignore the null characters and give me the full text or failing that
I can convert the raw ASCII data easily enough so if I could just get it to return the hex string that would be fine too.

RE: Problem getting data from a string field storing Binary data

@CODE (string)  or  @HEX (number) any use ?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close