Friday, June 13, 2014

ASCII Table

First Column in the below ASCII table represents Control Codes which are non-printable

ASCII_Table

Tip:
To know the ASCII value of characters in a table column ,Use DUMP function.
DUMP(<value> [,<return_format>[,<start_position>[,<length>]]])
Ex: SELECT PRODUCT_DESC,dump(PRODUCT_DESC) from W_PRODUCT_D;
NO. 40_DRILL, JOBBER_SOLID CARBIDE_ RSC0.0980ST
Typ=1 Len=47: 78,79,46,32,52,48,95,68,82,73,76,76,44,32,74,79,66,66,69,82,95,83,79,76,73,68,32,67,65,82,66,73,68,69,95,30,82,83,67,48,46,48,57,56,48,83,84
SELECT dump(PRODUCT_DESC,8) from W_PRODUCT_D –Returns Octal format
lly below numbers can be used to display in various formats

8 Octal
10 Decimal
16 Hexidecimal
17 Single Characters
1008 octal notation with the character set name
1010 decimal notation with the character set name
1016 hexadecimal notation with the character set name
1017 single characters with the character set name





No comments:

Post a Comment