What’s the difference between VARCHAR and CHAR?

VARCHAR is variable-length.

CHAR is fixed length.

If your content is a fixed size, you’ll get better performance with CHAR.

See the MySQL page on CHAR and VARCHAR Types for a detailed explanation (be sure to also read the comments).

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Unknown column in ‘field list’ error on MySQL Update query
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. MySQL – Operand should contain 1 column(s)
  5. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. MySQL create table if not exists and insert record only if table was created
  8. How do I use properly CASE..WHEN in MySQL
  9. How can I do a FULL OUTER JOIN in MySQL?
  10. MySQL query String contains
  11. Case statement in MySQL
  12. How to declare a variable in MySQL?
  13. MySQL Cannot Add Foreign Key Constraint
  14. How to split the name string in mysql?
  15. How do I import an SQL file using the command line in MySQL?
  16. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  17. mysql Foreign key constraint is incorrectly formed error
  18. MySQL: Invalid use of group function
  19. How can I return pivot table output in MySQL?
  20. Compare dates in MySQL
  21. MySQL “WITH” clause
  22. MySQL Multiple Joins in one query?
  23. Error Code: 2013. Lost connection to MySQL server during query
  24. MySQL syntax for Join Update
  25. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  26. how to drop partition without dropping data in MySQL?
  27. MySQL combine two columns into one column
  28. Simple way to calculate median with MySQL
  29. Error 1046 No database Selected, how to resolve?
  30. MySQL Error 1264: out of range value for column
  31. Remove duplicate rows in MySQL
  32. How to SUM and SUBTRACT using SQL?
  33. Cast from VARCHAR to INT – MySQL
  34. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  35. How do you force mysql LIKE to be case sensitive?
  36. MySQL – UPDATE multiple rows with different values in one query
  37. How to create a MySQL hierarchical recursive query?
  38. ERROR 1148: The used command is not allowed with this MySQL version
  39. Insert into a MySQL table or update if exists
  40. How to round down to nearest integer in MySQL?
  41. MySQL starts with searching issue
  42. Query to convert from datetime to date mysql
  43. Is it possible to GROUP BY multiple columns using MySQL?
  44. MySQL error: key specification without a key length
  45. Best way to test if a row exists in a MySQL table
  46. Check if MySQL table exists without using “select from” syntax?
  47. MySQL equivalent of DECODE function in Oracle
  48. mysql update column with value from another table
  49. The used SELECT statements have a different number of columns
  50. How to delete from multiple tables in MySQL?
  51. MySQL: Can’t create table (errno: 150)
  52. How to copy a row and insert in same table with a autoincrement field in MySQL?
  53. Join vs. sub-query
  54. Alternative to except in MySQL
  55. Equivalent of explode() to work with strings in MySQL
  56. ROW_NUMBER() in MySQ
  57. MySQL OPTIMIZE all tables?
  58. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  59. MySQL – Get row number on select
  60. MySQL error: Unknown column in ‘where clause’
  61. How to truncate the text returned for a column in a MySQL query
  62. Using union and order by clause in mysql
  63. MySQL LIKE IN()?
  64. The wait operation timed out. ASP
  65. When should I use CROSS APPLY over INNER JOIN?
  66. Insert Data Into Temp Table with Query
  67. SQL SELECT WHERE field contains words
  68. ORA-01843 not a valid month- Comparing Dates
  69. How do I escape a single quote in SQL Server?
  70. How to join two tables by multiple columns in SQL?
  71. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  72. Arithmetic overflow error converting numeric to data type numeric
  73. I want to use CASE statement to update some records in sql server 2005
  74. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  75. what is the difference between triggers, assertions and checks (in database)
  76. Replacing NULL with 0 in a SQL server query
  77. Error converting data type varchar
  78. I want to use CASE statement to update some records in sql server 2005
  79. What are database constraints?
  80. Postgresql column reference “id” is ambiguous
  81. Inner Joining three tables
  82. How do you properly prepare a %LIKE% SQL statement?
  83. Sorting search results by taxonomy terms
  84. Getting wrong relationship value in $args in wp_Query?
  85. How to properly sanitize strings without $wpdb->prepare?
  86. What SQL / WordPress queries would need a nonce?
  87. posts_where Fails with More than One Custom Field in Query
  88. Slow WP_Query for custom post type
  89. WordPress database error: You have an error in your SQL syntax
  90. Restose content from revisions – sql query
  91. $wpdb->insert() does not Insert record in a table
  92. WordPress SQL Issue not returning correct reselts
  93. Inner Join user tables to select users with roles
  94. $wpdb->prepare with LIKE returning blank array instead of rows
  95. Removing posts by sql
  96. Show Mysql table elements as pages in WordPress
  97. Data is not constatntly loading from custom wordpress table
  98. Delete oldest wordpress post (SQL query)
  99. optimise SQL wordpress call
  100. SQL to transform all email addresses in my DB in lowercase [closed]

Leave a Comment