wwwsqldesigner icon indicating copy to clipboard operation
wwwsqldesigner copied to clipboard

The drop down menu for 'type' does not have more than 5 options

Open sobopla opened this issue 7 years ago • 2 comments

I see in the video that the dropdown menu for type contains many more options such as 4 options for DATE & TIME, 4 options for NUMERIC, etc. I only see these options for type: Text, Numeric, Integer, Real, None. I'd like to be able to choose DATE Please advise using chrome, sqlite, ad block diabled

sobopla avatar Jul 07 '17 17:07 sobopla

I see that it is a chrome issue, as more of the dropdown options for type are showing in Firefox. However cookies for the site are enabled.

sobopla avatar Jul 07 '17 18:07 sobopla

The data type selection is database-specific, so you will see different data types available for different database types. In your case, SQLite has only five data types (fun fact: those are not real data types; instead, SQLite uses the concept of data affinity). If you switch your DB to a different one, reload the app and start a new design, you should see a different data type set.

Sanity check: open the blank wwwsqldesigner page using a private browsing window. You should see the default (MySQL) data type selection.

ondras avatar Jul 07 '17 18:07 ondras