Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Maximum Value for unsigned integer

Status
Not open for further replies.

tony2974

Technical User
Nov 22, 2006
1
US
Hi!

I am using Sybase IQ 12.6, I would like to know the maximum numeric value I can store in the sybase database table's column if it's datatype is "unsigned int".


Data type Maximum Value Minimum Value
tinyint - -
small int - -
unsigned int - -
int - -
char - -
varchar - -

Kindly also let me know some tips for conversion from one datatype to another.
e.g in Oracle we had to_char(<column_name of integer or date type>) to convert from numeric/date to char.

I am trying to learn sybase after a long stint with oracle8i/9i/10g

Regards,
Tony.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top