SQL 7 Datatypes

<i><b>Originally posted by : George (gplemos@email.com)</b></i><br /><br />I'm just getting used to using SQL 7 Database and am looking for some recommendations on what DATA TYPES to use when designing tables.<br /><br />The site I am working on now uses cold fusion to enter, update, and insert mainly text and articles. Now the problem with the articles is that some of them are pretty big. And when inserting or updating them, if they go over the limit of characters I get an error.<br /><br />I know in access I used to use the data type "MEMO" and be able to put a large piece of info in that field.<br /><br />What's the equivalent for SQL server databe?<br /><br />What are the most used/common or recommended data types that should be used when putting tables together?<br /><br />Thanks<br /><br />George

<i><b>Originally posted by : Murugan (mugas25@yahoo.com)</b></i><br /><br /><br /><br />------------<br />George at 10/2/2000 10:16:46 PM<br /><br /><br />I'm just getting used to using SQL 7 Database and am looking for some recommendations on what DATA TYPES to use when designing tables.<br /><br />The site I am working on now uses cold fusion to enter, update, and insert mainly text and articles. Now the problem with the articles is that some of them are pretty big. And when inserting or updating them, if they go over the limit of characters I get an error.<br /><br />I know in access I used to use the data type "MEMO" and be able to put a large piece of info in that field.<br /><br />What's the equivalent for SQL server databe?<br /><br />What are the most used/common or recommended data types that should be used when putting tables together?<br /><br />Thanks<br /><br />George<br /><br />Dear George,<br /><br />in SQL you use Varchar data type<br />this data type limit is 8000 characters.<br />don't worry about it.<br />with regards<br />mugas<br />

<i><b>Originally posted by : Chris Chong (cuttybebe@yahoo.com)</b></i><br />Well, some article might be longer than 8k characters. So my suggestion will be Text data type. This data type can holds unlimited characters.<br /><br />------------<br />Murugan at 10/18/2000 1:04:37 AM<br /><br /><br /><br /><br />------------<br />George at 10/2/2000 10:16:46 PM<br /><br /><br />I'm just getting used to using SQL 7 Database and am looking for some recommendations on what DATA TYPES to use when designing tables.<br /><br />The site I am working on now uses cold fusion to enter, update, and insert mainly text and articles. Now the problem with the articles is that some of them are pretty big. And when inserting or updating them, if they go over the limit of characters I get an error.<br /><br />I know in access I used to use the data type "MEMO" and be able to put a large piece of info in that field.<br /><br />What's the equivalent for SQL server databe?<br /><br />What are the most used/common or recommended data types that should be used when putting tables together?<br /><br />Thanks<br /><br />George<br /><br />Dear George,<br /><br />in SQL you use Varchar data type<br />this data type limit is 8000 characters.<br />don't worry about it.<br />with regards<br />mugas<br />