Answer the question
In order to leave comments, you need to log in
Does this take away the benefit of using fixed-length strings?
As far as I understand, the main advantage of fixed-length strings over variable-length strings is the speed of accessing such columns. However , here in the comments they write:
Note that using CHAR will only speed up your access if the whole record is fixed size. That is, if you use any variable size object, you might as well make all of them variable size. You gain no speed by using a CHAR in a table that also contains a VARCHAR.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question