• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 600
  • Last Modified:

finding asci value of non printable character

There us some sort of unprintable character at the end of several of my input recs in a varchar (30) description column. It is causing the usual mayhem by being treated as a delimeter and splitting the record. They are not the usual ascii values (I think 10 and 14) for newline and tab.  Can I dump this column to get the value.  From there I can either translate it or replace it.
  • 2
2 Solutions
slightwv (䄆 Netminder) Commented:
There is a dump sql function.  Check out:
You can use the ASCII(str) function but it works on the first char in str
You can combine ascii with right, e.g.

select ascii(substr(somecol, -1,1)) from tbl
select ascii(substr(somecol, -2,1)) from tbl
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now