Ycsoftware.net
Menu
  • Databases
    • MySQL
    • MS SQL Server
    • Foxpro
  • Programming
    • .NET
    • C#
    • Drupal
    • Java
    • PHP
    • Javascript
  • System Administration
    • Hardware
    • Linux
    • MAC
    • Virtual Servers
    • VMWARE
    • Servers
    • VirtualBox
  • Web Design
    • CSS
    • Flash
    • HTML
    • SEO
  • Other
  • Contact Us
    • About Us

MySQL and MSSQL Maximum Integer (Numeric) Values

  • March 30, 2011

MySQL

TINYINT       127

SMALLINT      32767

MEDIUMINT     8388607

INT           2147483647

BIGINT        9,223,372,036,854,775,807

MSSQL

TINYINT	      255

SMALLINT      32767

INT	      2147483647

BIGINT	      9,223,372,036,854,775,807

Reference

MSSQL

http://msdn.microsoft.com/en-us/library/aa258271(v=sql.80).aspx

MySQL

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

  • Posted in: Databases, MS SQL Server, MySQL, Programming
Next Post »
« Previous Post

Search

Search

YCSoftware Recent Comments

THANKS!!!.. worked like a charm......
It works!...
THANKS! FIXED the problem I was having!!! :) openSUSE LEAP 15.0 m...
perfect, thanks much...
thanks a lot...
Love it bro that worked for me thank you...
Same error, but on Mac, any ideas?...
Thanks very much !!!...
Just testing...
Awesome, problem solved. Thanks man....

Tags

.net C# Centos 5 interest internet Microsoft Access Microsoft Office Programming technology thinker vmware vmware tools

Sponsors

YCSoftware
  • © 2025 Ycsoftware.net
Top