Last answered:

15 Nov 2022

Posted on:

25 Jun 2022

0

Resolved: Why is VAR(N) not a data type?

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)
Instructor
Posted on:

25 Jun 2022

1

Hi Yinka!
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.
Best,
Tsvetelin

Posted on:

15 Nov 2022

0

Hi,

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