Tag Info

New answers tagged


Summary: VARCHAR and TEXT are identical for reading, storing, FULLTEXT, and virtually everything else. Some INDEX/SELECT differences are noted below. MariaDB and MySQL are (I'm pretty sure) the same as each other in this area. Some reason for 765? What CHARACTER SET are you using? (Ascii versus utf8 -- there could be differences.) For "small" VARCHARs ...


As far as Postgres is concerned, there is no difference in performance. And there is no length modifier for text to begin with, just (optionally) for varchar. Unless you need to enforce a certain length, just use text or varchar. Would index lookup be noticeably faster with char vs varchar when all values are 36 chars To support pattern matching with ...

Top 50 recent answers are included