Resolved: Why is VAR(N) not a data type?
in SQL / String data types
Why is VAR(10) not a data type in the exercise considering that 'N' can be considered as the length of the string except if this is in line with the notion that 'N' is different from 'n' as taught in Statistics? In case that will CHAR(n) be considered a data type?
2 answers ( 1 marked as helpful)
Thanks for reaching out.
The answer A is incorrect because the CHAR data type is expecting a number and not a letter. You can see that answer D shows just that.
Hope this helps.
It seems unclear that why char(N) is the correct answer.
This it was not clarified clearly in lecture that char is expecting a number rather than a letter, while in examples used ´James´ as CHAR data type.
Submit an answer
Why did you not do not null, primary key and auto increment for customer id in the solution?
The schema section does not show the tables in the Tables subsection.