INT Datatype in MySQL

Question

Does the INT, TINYINT, MEDIUMINT, BIGINT in MySQL Accepts the character '-' ? I used the data type INT in a column and the data inside has the character '-'. And somehow it didn't accept it. If it's not possible for INT data types, should I use VARCHAR?

Anant Dabhi · Accepted Answer · 2014-03-25 11:04:06Z

1

The values for an integer in SQL are:

-2147483648 through 2147483647

And the byte size is 4 bytes.

Other maximum values:

BigInt: -9223372036854775808 through 9223372036854775807 (8 bytes)
SmallInt: -32768 through 32767 (2 bytes)
TinyInt: 0 through 255 (1 byte)

it dosent accept any char or string values like "-"

use varchar datatype if u want to insert "-"

answered Mar 25, 2014 at 11:04

Anant Dabhi

11.2k3 gold badges33 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

UdayKiran Pulipati · Accepted Answer · 2014-03-25 11:03:24Z

1

Use VARCHAR(45) or TEXT datatype, if you want to insert characters.

answered Mar 25, 2014 at 11:03

UdayKiran Pulipati

6,6977 gold badges70 silver badges95 bronze badges

Comments

Vignesh Kumar A · Accepted Answer · 2014-03-25 11:03:29Z

1

you have to use Varchar DataType for this.

It will support both Int and Special Symbol like '-'

If you are not going to do any arithmetic operaion means then you can use Varchar or text DataType

answered Mar 25, 2014 at 11:03

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Collectives™ on Stack Overflow

INT Datatype in MySQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related