You are not logged in.
- Topics: Active | Unanswered
#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,622
- 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
likely the nonsignificant digits are just dropped..instead of .... zero filled...
0000000000000000000000001
vs
1that would be my guess..though it is just that at this point..a guess.
hmm.. well sounds like a reasonable guess cactus 
.oO Komodo Dave Oo.
Offline