Results 1 to 7 of 7

Thread: hex encoding

  1. #1
    Join Date
    Aug 2010
    Posts
    4

    Unanswered: hex encoding

    i'm doing a bcp of an old sybase database and it all comes out in the native format, i've done it on dos and tru64 and it's the same thing, which leads me to believe that the native is native to sybase, so i was just wondering how to decode the stuff, i don't know very much more than the absolute basics, so any help would be a preciated,

    Thanks.

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Are you using the -c option with the BCP command to get character output?

  3. #3
    Join Date
    Aug 2010
    Posts
    4
    no, because the original plan was to remove it from the original database, then but it on another one and extract it from there (not my idea, but aparently that's how it has to be done)

  4. #4
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Well I'd suggest using the -c option and seeing if that solves your problem. If it doesn't then please supply more details ie table definitions, some example output from the bcp command and a good description of what the problem actually is

  5. #5
    Join Date
    Aug 2010
    Posts
    4
    I talked to my boss and now i understand the problem, so here it is, we only have one database as the other is down, inorder to get it out in a human readable fashion we need to bcp in to the other server, but sinse it is dead It falls on me to learn how to be a computer and translate all this stuff, here's the example he gave me to learn off of.

    010000000D00000004000000000A006B656E6F72615F716331 0100040100000016004B656E6F72613A20436F727265637465 6420666C6F770100010006006B656E6F7261D4FE01006E0100 7901006E0F000A000100799F00000000000000040000000004 000000000000020000003600000004000000000B00

    that is the output, i need to translate into this

    1 13 0 kenora_qc1 1 1 Kenora: Corrected flow 1 1 kenora -300 n y n 15 10 y 159 0.0 0 0

  6. #6
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    And did you try using the -c option with BCP to get your human readable form?

  7. #7
    Join Date
    Aug 2010
    Posts
    4
    disregard this thread, turns out it has nothing to do with sybase, infact it's the exact oposite, i don't have any database that i could just -c to
    thanks for your time

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •