In oracle11g excuse me A field type is CHAR (5), such as the field in the 'A', I do the query can speak in the 'A' found out directly, why back to automatic TRIM, actually should save in the database is' A 'is not A code? The CHAR type is not automatic filling the blank space?

CodePudding user response:

https://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements002.htm#SQLRF51043

As a "Blank - Padded" char types, more rules is' a '=' a '

CodePudding user response:

Char matching is
But should be default is characters at the back of the Spaces don't match, the space in front of the