Julián Elizondo
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
0

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
2

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

Submit an answer

related questions

Rhys Morgan
3
28
Rollback not reverting DB state after using INSERT INTO
Jose Luis Loren
4
12
Alternative code using group by
kfir ben galil
0
10
Resolved: using the exists key word
Geetanjali Juneja Upadhyay
0
6
15. sql subquires--Can you please help to find out why in the video you are using the dept_emp table
Abdul Rehman
0
6
Resolved: Why you are using different query editor for like new query for table creation of sales then new que
Saeed Ehsanfar
0
6
Need clarification on why using e.emp_no < 10011 in the WHERE clause
Christine Li
0
6
Will "<0" (less than zero) include null values?
Maimuna Khatoon
0
6
Getting different result on Count Function using >1 inside the bracket. Kindly explain?