I am new to mySQL and have some questions:
1. Will the TEXT type receive the same size as the input or is it fixed? (If I input 1kb of text, will the db increase 1kb or 6,5kb which is the maximum of that type?)
2. Is the TEXT much slower than the CHAR. If I have 254 characters in a CHAR and 254 characters in a TEXT type, will the search take much longer in the TEXT type. (When searching several records).
3. Is the content in TEXT stored in another way than in the CHAR? (Will any characters stored look different, disappear or something like that?)
Thanks / Henrik
1. Will the TEXT type receive the same size as the input or is it fixed? (If I input 1kb of text, will the db increase 1kb or 6,5kb which is the maximum of that type?)
2. Is the TEXT much slower than the CHAR. If I have 254 characters in a CHAR and 254 characters in a TEXT type, will the search take much longer in the TEXT type. (When searching several records).
3. Is the content in TEXT stored in another way than in the CHAR? (Will any characters stored look different, disappear or something like that?)
Thanks / Henrik