PDA

View Full Version : SQL Problem


Little Nicky
30-05-2003, 01:36 AM
Okay, I've got a problem. I need to declare an SQL variable inside a table, and it needs to be one that can hold an indefinate amount of text. Now the char and varchar types can only hold 255 characters at the most ... but there must be a type used, say, in this forum, that can hold more? I know this forum uses SQL, so maybe one of the Admins can help me here?

I would really aprecciate some help. Thanks.

Shaun-3DT
01-06-2003, 08:57 AM
What type of database are you using?

For Access there is a Memo field type which can hold up to a Gig I think.
For Sql Server you can have a Varchar up to around 8000 or a Text type field which can be any size but is not that great from a performance perspective.

If you're using MySQL then the Text field will take you to around 60k, MediumText around 16 mg and LongText to about 4Gb, this is what I remember from about a year back, could've changed if there is a new version.

Cheers
Shaun

Little Nicky
04-06-2003, 12:52 AM
OK, thanks Shaun. I'm using a MS Access DB. I'll try Memo.

Thanks again!