Getting an extra space at the end of the record in Toad (187356)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting an extra space at the end of the record in Toad
Description

In Toad Data Point, working with SQL Server, after a query was executed, in the data grid, there was a column with data showing extra spaces ( right padded with blanks ). See image below:
Cause

If the value provided to a variable of CHAR data type is shorter than the length of the declared column size, then the value would be right-padded with blanks to match the size of column length.
Resolution

RESOLUTION:
In order to delete the extra space, this query can help:
UPDATE
TABLE NAME
SET
COLUMN NAME = LTRIM(RTRIM(COLUMN NAME))
Also, keep in mind: Working with Varchar will avoid to create the extra space at the end. But if the extra space was already generated, run this query (the one above), will fix the situation.
Additional Information

Note: If SET ANSI_PADDING is OFF when CREATE TABLE or ALTER TABLE is executed, a CHAR column defined as NULL is considered as VARCHAR.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title