char Pronounciation

char Description

The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing spaces are retained.

The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. For example, CHAR(30) can hold up to 30 characters.

The length of a CHAR column is fixed to the length that you declare when you create the table. The length can be any value from 0 to 255. When CHAR values are stored, they are right-padded with spaces to the specified length. When CHAR values are retrieved, trailing spaces are removed unless the PAD_CHAR_TO_FULL_LENGTH SQL mode is enabled.

Maybe you are interested

Spotify Verilog Streamlio Vespa Deis Jedis Redisson Mockito YUI SciPy scikit-learn IPython LaTeX Scrapy SymPy Ceylon Grafana Morphix Knoppix SHA256 AUR Feren Zorin Manjaro HashiCorp swf swc fla C10K Minikube SFINAE Luminoth stdio FFmpeg Paramiko Kryo ArangoDB Apigee apt-get apt Atlassian Kombu Nike IELTS Libvirt Neo4j ROM Jekyll Nette Agavi