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

Submit an answer

related questions

Rhys Morgan

Rollback not reverting DB state after using INSERT INTO

Jose Luis Loren

Alternative code using group by

kfir ben galil

Resolved: using the exists key word

Abdul Rehman

Resolved: Why you are using different query editor for like new query for table creation of sales then new que

Meenakshi Akila P.S

using aliases in order by clause

Saeed Ehsanfar

Need clarification on why using e.emp_no < 10011 in the WHERE clause

Geetanjali Juneja Upadhyay

15. sql subquires--Can you please help to find out why in the video you are using the dept_emp table

Christine Li

Will "<0" (less than zero) include null values?

Maimuna Khatoon

Getting different result on Count Function using >1 inside the bracket. Kindly explain?

Wai Tak Tung

Some employees has more than one emp_no?

Islam Elkhateeb

I have a different answer than 365 data solution when I this code

Ayush Sahu

Resolved: about using manager_id as 10022