|
Replies:
1
-
Pages:
1
-
Last Post:
Dec 10, 2010 4:30 AM
by: SuperDuperBongo...
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
5
Registered:
6/1/10
|
|
|
|
Alter Table with Bit(2)
Posted:
Nov 22, 2010 5:46 PM
|
|
|
Currently if you have a column that is 2 bits, if you alter that column on the table, to change the default from lets say '00' to '01' the sql generated changes BIT(2) to BIT. Also in the column definition you are not able to sepecify a length of the BIT column
|
|
|
Posts:
5
Registered:
11/18/10
|
|
|
|
Re: Alter Table with Bit(2)
Posted:
Dec 10, 2010 4:30 AM
in response to: x21_921
|
|
|
I have also had problems with Toad and BIT typed columns with a specified length.
The BIT type has changed somewhat reasonably through MySQL releases. I don't think that Toad considers this properly.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
