Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Last answered:

11 Jan 2023

Posted on:

09 Jan 2023


Resolved: Using CHAR(n) with a String with a Longer Length than CHAR(n)

Is it possible to, for example, type the name 'Robert' in a CHAR string data type with a value of 5?

1 answers ( 1 marked as helpful)
Posted on:

11 Jan 2023


Hi Julian!
Thanks for reaching out.

This will give you the first 5 characters and the result will be: 'Rober'. You have to specify lengths that are long enough. Good practice is using CHAR(255) or VARCHAR(255).

Hope this helps.

Submit an answer