Skip to Content
author's profile photo Former Member
Former Member

isql output is Hexadecimal

Use isql command on Linux connect ASE 12.5 and try to access any table in mydb like

select * from mytab

All output is Hexadecimal. but if I access this database with tool like powerbuilder, the output is readable and fine.

What's wrong for this case? how to figure out and fix it?this never happened before.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jun 12, 2014 at 02:32 PM

    Is the data in UTF - e.g. UTF8??? and if so, did you connect with isql -Jutf8???

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 12, 2014 at 02:27 PM

    The behavior doesn't sound familiar.

    what version of isql (isql -v) ?

    perhaps post a brief example of the output?

    is this really specific to just a particular database ("this database"), i.e. doesn't happen if you select * from master..sysusers, for example?

    Do you have any unusual traceflags active (dbcc traceon(3604), go, dbcc traceflags, go)?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      example:

      1> select bank from my_bank

      2> go

      bank

      ----------------------------------------------------------------------------------

      0x420044004f00

      0x4300490054004900420041004e004b00

      0x4d0041005900420041004e004b00

      0x530059005300540045004d00

      0x55004e0049004f004e00420041004e004b00

      (5 rows affected)

      master is fine. no this problem. nothing changed for this ase. I have three boxes with same platform and same database. all of them looks like have same issue.

      the way I connect to Linux is: I use PuTTY. I do this everyday and no problem. Not sure why.

      I try to connect to ASE with pb, Sybase central, and run isql, no problem. the plain data is:

      BDO

      CITIBANK

      MAYBANK

      SYSTEM

      UNIONBANK

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.