Regarding ASCII data type

[srs_grp]

Does SQL support ASCII data type?Or we need to do some type casting for it.?

[dickersonka]

not really sure what you are meaning

all characters will have an int value, and you can translate the int value back to a char

you can use ascii(char)
or
char(ascii)

select ascii('q')
-- returns 113

select char(113)
-- returns 'q'

[srs_grp]

not really sure what you are meaning

all characters will have an int value, and you can translate the int value back to a char

you can use ascii(char) or char(ascii)

select ascii('q')
-- returns 113

select char(113)
-- returns 'q'

////////////////////////
Actually for r project, we need to store fields having data type as ASCII characters and we are not getting how to do it?

[dickersonka]

Having data type as what?

What are you not understanding?