I want to design a database for MySql.
I define a column with type (say) INT and no length specified.
I generate the sql script create table ...
The create table statement specifies a column with type INT(): NOK, this is not accepted by MySql.
I want a column of type INT (with no parenthesis and no length specified): NOK: not possible to generate that with ISDesigner.
The only way to generate a valid sql script is to specify a length every time ...
This issue applies to all numeric types.
I want to design a database for MySql. I define a column with type (say) INT and no length specified. I generate the sql script create table ... The create table statement specifies a column with type INT(): NOK, this is not accepted by MySql. I want a column of type INT (with no parenthesis and no length specified): NOK: not possible to generate that with ISDesigner. The only way to generate a valid sql script is to specify a length every time ... This issue applies to all numeric types.