Data types for Text fields
Posted: 2014-07-29 09:20
Hi,
I am not very well acquainted with data types and was interested to know if anyone could give me a straight forward answer to the best data type to store reports. I have searched on Google but frankly I am confused between TEXT, BLOB and VARCHAR and their various derivatives as text storage types.
I am designing a database that will store client data and some fields are reports. There are 9 sub reports of about 750 - 1000 characters and 1 final report of about 5000 - 6000 characters.
I addition to that there are 15 fields that contain typical contact information including dates, telephone and email. For the email and date fields I understand there are specific data types and that's fine but which text data type is best for First Name, Surname, Ad 1, Ad 2, etc. (i.e. straight forwards short text strings)? I have tried various types on AppGini and all appear to display the same when the code is generated but as I understand it, there is a significant difference in the amount of memory consumed in each case. The database will contain about 5-6 thousand records.
I have noticed that when I select "Rich (HTML) area" option a text editor is applied to the field which is great. However, after formatting the text as required and viewing it in a "Print Preview" which works fine, when returning back to the detail view the text formatting has apparently disappear. However, when doing a "print preview" again the text formatting is still there. As the reports will be frequently revisited throughout a period of consultation with the client, it would be preferable if the Detail View continuously displayed the formatted text. Is this possible?
I know these enquiries must seem basic but some straight forward, jargon free, help would be appreciated.
Thanks
Trevorm
I am not very well acquainted with data types and was interested to know if anyone could give me a straight forward answer to the best data type to store reports. I have searched on Google but frankly I am confused between TEXT, BLOB and VARCHAR and their various derivatives as text storage types.
I am designing a database that will store client data and some fields are reports. There are 9 sub reports of about 750 - 1000 characters and 1 final report of about 5000 - 6000 characters.
I addition to that there are 15 fields that contain typical contact information including dates, telephone and email. For the email and date fields I understand there are specific data types and that's fine but which text data type is best for First Name, Surname, Ad 1, Ad 2, etc. (i.e. straight forwards short text strings)? I have tried various types on AppGini and all appear to display the same when the code is generated but as I understand it, there is a significant difference in the amount of memory consumed in each case. The database will contain about 5-6 thousand records.
I have noticed that when I select "Rich (HTML) area" option a text editor is applied to the field which is great. However, after formatting the text as required and viewing it in a "Print Preview" which works fine, when returning back to the detail view the text formatting has apparently disappear. However, when doing a "print preview" again the text formatting is still there. As the reports will be frequently revisited throughout a period of consultation with the client, it would be preferable if the Detail View continuously displayed the formatted text. Is this possible?
I know these enquiries must seem basic but some straight forward, jargon free, help would be appreciated.
Thanks
Trevorm