GarryTwine
MIS
Does anyone have any advise on the advantages / disadvantages of either field type. When does a VARCHAR become more efficient than a CHAR? ie Is there an optimum length of CHAR when VARCHAR should be considered?
What about with regard to substring searches? Is it more efficient to perform a search on a 200 character field or on a 200 varchar field?
Any advice most welcome.
What about with regard to substring searches? Is it more efficient to perform a search on a 200 character field or on a 200 varchar field?
Any advice most welcome.