You are not logged in.

#1 2006-04-15 00:24:43

Komodo
Member
From: Oxford, UK
Registered: 2005-11-03
Posts: 674

MySQL -> Unsigned vs Unsigned Zerofill

'Unsigned Zerofill' means column rows are automatically assigned the UNSIGNED attribute. So what happens if you set a column to just 'UNSIGNED'?


.oO Komodo Dave Oo.

Offline

#2 2006-04-21 11:46:19

Komodo
Member
From: Oxford, UK
Registered: 2005-11-03
Posts: 674

Re: MySQL -> Unsigned vs Unsigned Zerofill

Come on, bajillions of you use MySQL, I can't find the answer in the MySQL documentation, but I'm betting one of you clever folk must know...


.oO Komodo Dave Oo.

Offline

#3 2006-04-21 20:46:24

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,615
Website

Re: MySQL -> Unsigned vs Unsigned Zerofill

likely the nonsignificant digits are just dropped..instead of .... zero filled...

0000000000000000000000001
vs
1

that would be my guess..though it is just that at this point..a guess.


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#4 2006-04-22 09:35:10

Komodo
Member
From: Oxford, UK
Registered: 2005-11-03
Posts: 674

Re: MySQL -> Unsigned vs Unsigned Zerofill

cactus wrote:

likely the nonsignificant digits are just dropped..instead of .... zero filled...

0000000000000000000000001
vs
1

that would be my guess..though it is just that at this point..a guess.

hmm.. well sounds like a reasonable guess cactus  smile


.oO Komodo Dave Oo.

Offline

Board footer

Powered by FluxBB