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 very much !!!...
Just testing...
Awesome, problem solved. Thanks man....
REboot the MAC and Try to redownload the JDK. It might be that the JDK...
When I download the new JDK for Mac it says the disk image is not reco...
You are my hero for posting this....
Greetings! Very useful advice in this particular article! It's the ...
I love what you guys are up too. This type of clever work and reportin...
relates to. To fix that you can either include the path to mysqldump e...
By implementing all these third-party tacked on start menus, all we’...

Tags

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

Sponsors

YCSoftware
  • © 2025 Ycsoftware.net
Top