MySQL Forums
Forum List  »  Docs

Error in documentation?
Posted by: Владислав Сокол
Date: December 22, 2019 10:55PM

The topic "The CHAR and VARCHAR types" ( ) contains the next phrase:

If a given value is stored into the CHAR(4) and VARCHAR(4) columns, the values retrieved from the columns are not always the same because trailing spaces are removed from CHAR columns upon retrieval. The following example illustrates this difference:

But following example demonstrates that trailing spaces are removed from VARCHAR type field and NOT removed from CHAR.

Options: ReplyQuote

Written By
Error in documentation?
December 22, 2019 10:55PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.