SQL Problem

Little Nicky · 30-05-2003, 12: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, 07: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 · 03-06-2003, 11:52 PM

OK, thanks Shaun. I'm using a MS Access DB. I'll try Memo.

Thanks again!

30-05-2003, 12:36 AM	#1
Little Nicky PG Rated Join Date: Jan 2003 Location: Levin, New Zealand Posts: 97 Thanks: 0 Thanked 0 Times in 0 Posts	SQL Problem 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. __________________ Be Unafraid. Be very Unafraid.

01-06-2003, 07:57 AM	#2
Shaun-3DT Administrator Join Date: Sep 2002 Location: Norwich Posts: 237 Thanks: 0 Thanked 0 Times in 0 Posts	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 __________________ World Domination Through Superior Software

03-06-2003, 11:52 PM	#3
Little Nicky PG Rated Join Date: Jan 2003 Location: Levin, New Zealand Posts: 97 Thanks: 0 Thanked 0 Times in 0 Posts	OK, thanks Shaun. I'm using a MS Access DB. I'll try Memo. Thanks again! __________________ Be Unafraid. Be very Unafraid.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)