Differentiate CHAR_LENGTH and LENGTH?
- 1 Answers
- 1081 Views
- I also Faced
- E-Mail Answers
Differentiate CHAR_LENGTH and LENGTH?..
Answer / Ashish Babu
In MySQL, `CHAR_LENGTH()` returns the length of a string without considering any trailing spaces. On the other hand, `LENGTH()` counts all characters, including leading and trailing spaces.
| Is This Answer Correct ? | 0 Yes | 0 No |
More MySQL Interview Questions
How does triggers work in mysql?
How to dump a table to a file with 'mysqldump'?
How do I change directories in mysql?
How do I automate a backup in mysql?
Can mysql and mariadb coexist?
how we connect the data base in any programme
How do I view a mysql database?
How do I run mysql?
How to control the max size of a heap table?
How to connect html form to mysql database using php?
How do I select a database in mysql workbench?
Can we store pdf files in mysql?
Categories
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
