1. Vertabelo
  2. Spørgsmål
0
Besvaret

(UN)SIGNED

Ken Gillett 10 år siden • opdateret af William Bell 7 år siden • 5
How can I specify whether an INTEGER is SIGNED or UNSIGNED?

I cannot see any reference to this.

Svar

Svar
Besvaret
Agnieszka Kozubek-Krycuń (Chief Scientist) 10 år siden
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.
Svar
Besvaret
Agnieszka Kozubek-Krycuń (Chief Scientist) 10 år siden
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
Ken Gillett 10 år siden
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
Agnieszka Kozubek-Krycuń (Chief Scientist) 10 år siden
The default is your database default, probably SIGNED. We don't have plans to change the UI with respect to signed/unsigned types.
+7
Ken Gillett 10 år siden
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.
William Bell 7 år siden

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.

Kundesupport af UserEcho