wwwsqldesigner
wwwsqldesigner copied to clipboard
The drop down menu for 'type' does not have more than 5 options
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
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.
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.