A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog


Category: ASE: Datatypes: Datatype Conversion Functions

strtobin()

The datatype conversion function strtobin() converts a hexadecimal value into a String, i.e. a series of characters. The converted output string is of the datatype varchar(255). strtobin() is a function not documented by Sybase®. It is available in ASE® starting with version 12.0.

Syntax of the Datatype Conversion Function strtobin()

    strtobin( hex_string )
    

The Parameter of the Datatype Conversion Function strtobin()

hex_string
The parameter "hex_string" is a placeholder for a hexadecimal value. The return value is prefixed with "0x". The parameter must be set into quotes.

Example for the Datatype Conversion Function strtobin()

    select strtobin("1A0F")
go
-----
0x1a0f