0
Z odpowiedzią

(UN)SIGNED

Ken Gillett 10 lat temu Ostatnio zmodyfikowane przez William Bell 7 lat temu 5
How can I specify whether an INTEGER is SIGNED or UNSIGNED?

I cannot see any reference to this.

Odpowiedź

Odpowiedź
Z odpowiedzią
Just type INTEGER UNSIGNED in the Type field. Only the most common types are shown in the Type selection layer. You can type whatever you want in the Type field, Vertabelo will verify if the type is correct.
Odpowiedź
Z odpowiedzią
Just type INTEGER UNSIGNED in the Type field. Only the most common types are shown in the Type selection layer. You can type whatever you want in the Type field, Vertabelo will verify if the type is correct.
+3
Hmm, that doesn't seem very satisfactory. Specifying SIGNED or UNSIGNED should be a simple checkbox. What's the default if you don't specify?
-3
The default is your database default, probably SIGNED. We don't have plans to change the UI with respect to signed/unsigned types.
+7
I think that's just lazy. If you really want to convince customers that your system is the best for database design/layout, I think you're going to have to do better than that.In particular with regard to your support for MySQL which is the most commonly used database and not some obscure product hardly used.

How hard could it be to actually implement such a feature in the GUI (a pair of radio buttons which default to the chosen database's default would be the correct way) and the required  back end code. Not very is the answer.

I agree - I just did an import of a table in SQL and it did not set the UNSIGNED. So it seems like a bug to me.