I am running SQL 6.5 server. I created a column in a table and used the 'text' datatype definition.My front end is Visual Basic 6.0. When storing into the database into this field,only a max of 255 characters are stored in the database, which is quite surprising. The rest of the characters are truncated.
I presume, 'text' datatype in SQL 6.5 should be able to store more than that. (16 bytes).Why is this problem occurring. I am not even able to specify the User Defined Data type. When creating a User Defined Data Type, I have to specify the Base Datatype to use and when I specify 'text', I am unable to specify the size and it takes the default to be 16 (bytes if I am correct... How many characters would that make ?).Using varchar and char is not possible since that only takes 255 char.
Please help ...