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

in SQL / String data types

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)

Tsvetelin Tsonkov

Instructor

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

Helpful answer

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

Submit an answer

related questions