 |  |  |  |  |  |  |  |
Regarding ASCII data type
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation: 
Solved Threads: 137
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)
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.
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
•
•
•
•
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?
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation:
Solved Threads: 137
Having data type as what?
What are you not understanding?
What are you not understanding?
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
|
Similar Threads
- What sql data type to use (Database Design)
- convert variable to ASCII number (C++)
- Reading Keyboard Data Direct From Port (Perl)
- How to check data type (Visual Basic 4 / 5 / 6)
- returning number of characters with ASCII code (C)
- help understanding "char" data type (C++)
- C++ Data Types (C++)
Other Threads in the Database Design Forum
- Previous Thread: Database design question
- Next Thread: e-r diagram
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Database Design Posts
- Today's Posts
- Unanswered Threads
