What happens if the length of the original string is greater than the length of the string returned after padding in LPAD() or RPAD() functions?

In this case, MySQL will not pad anything and truncate the characters from the original string up to the value of length provided as the argument in LPAD() or RPAD() functions.

Example

mysql> Select LPAD('ABCD',3,'*');
+--------------------+
| LPAD('ABCD',3,'*') |
+--------------------+
| ABC                |
+--------------------+
1 row in set (0.00 sec)

mysql> Select RPAD('ABCD',3,'*');
+--------------------+
| RPAD('ABCD',3,'*') |
+--------------------+
| ABC                |
+--------------------+
1 row in set (0.00 sec)

We can observe from the above example that both the functions do not pad ‘*’ and truncate the original string up to the length specified i.e. 3 as the argument.

Samual Sam

Published on 20-Feb-2018 08:37:36

• Related Questions & Answers
• What MySQL returns, if the length of the original string is greater than the length specified as an argument in LPAD() or RPAD() functions?
• How can we use MySQL LPAD() and RPAD() functions in the same query for padding the string to both sides, left and right, of the original string?
• What MySQL returns if we provide an empty string for padding with other string in LPAD() or RPAD() functions?
• Check if the frequency of any character is more than half the length of the string in Python
• What is the maximum length of string in Python?
• What is the max length of a Python string?
• How can we use LPAD() or RPAD() functions with the values in the column of a MySQL table?
• How MySQL LENGTH() function measures the string length?
• How to calculate the length of the string using C#?
• Find the Length of the Longest possible palindrome string JavaScript
• What happens if the substring is there for more than one time in the string given as the arguments of LOCATE() function?
• Python - Find the length of the last word in a string
• Display substring in MySQL if the string is less than a specific length or display a custom message if it is more?
• PHP program to find the length of the last word in the string
• C++ Program to Find the Length of a String