943,733 Members | Top Members by Rank

Web Development > Databases > Database Design > Regarding ASCII data type
Ad:
Permalink
Sep 18th, 2008
0

Regarding ASCII data type

Expand Post »
Does SQL support ASCII data type?Or we need to do some type casting for it.?
Similar Threads
Reputation Points: 9
Solved Threads: 0
Light Poster
srs_grp is offline Offline
34 posts
since Sep 2008
Permalink
Sep 18th, 2008
0

Re: Regarding ASCII data type

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'
Last edited by dickersonka; Sep 18th, 2008 at 10:52 am.
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Permalink
Sep 22nd, 2008
0

Re: Regarding ASCII data type

Click to Expand / Collapse  Quote originally posted by 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'





////////////////////////
Actually for r project, we need to store fields having data type as ASCII characters and we are not getting how to do it?
Reputation Points: 9
Solved Threads: 0
Light Poster
srs_grp is offline Offline
34 posts
since Sep 2008
Permalink
Sep 22nd, 2008
0

Re: Regarding ASCII data type

Having data type as what?

What are you not understanding?
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: Database design question
Next Thread in Database Design Forum Timeline: Help to Convert entity-relationship model into a relational database design.





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC