Does SQL support ASCII data type?Or we need to do some type casting for it.?
srs_grp -1 Light Poster
dickersonka 104 Veteran Poster
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 -1 Light Poster
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 104 Veteran Poster
Having data type as what?
What are you not understanding?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.