I have a table
TABLE1 with 400,000 row (by now) that has 20 columns.
I have a column
DETAIL that usually stores 100 to 300 characters, that's why its size is 1024, but I have an special case. I need to store 1900 chars for one row only.
The solution that I found is creating another column,
DETAIL2 to store remaining characters, but I'm afraid that this will cause my table size to increase a lot (just one row would have
DETAIL2, others will be
Is this the right solution or is there a better way to store the special case?