Clever Geek Handbook

How to understand if bigint is signed or not in mysql?

I have a table whose create statement is:

CREATE TABLE `takas` (
  `TAKAS_NO` bigint(20) NOT NULL,
  `FIYAT` decimal(20,2) NOT NULL,
  `MIKTAR` decimal(20,5) NOT NULL) 

...

is TAKAS_NO signed bigint or unsigned? I couldn't find the answer on the internet.

+3


source to share


2 answers


All ints are signed unless you specify that they are not specified:



CREATE TABLE foo (
   x int // signed
   y int unsigned // unsigned
);
+6


source


The answer is yes. All ints are signed

for more details see link http://ronaldbradford.com/blog/bigint-v-int-is-there-a-big-deal-2008-07-18/



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

+2


source






More articles:


All Articles