Choosing the proper data type

[Peppi]

Hi.

I am trying to program a message board similar to this one. I am unsure as to the proper data type to use for storing the actual messages. Obviously these messages can be quite long. Should I simply max out the VARCHAR data type at 2000 bytes?

Any advice is appreciated.

 

[Cagliostro]

If I understand what the your problem is, than this is really up to you....

Char is dztatype with fixed length at what you specified, but varchar is not larger than what you specified.

John Fill
ivfmd@mail.md

 

[Peppi]

Another problem...

I'm using Access as the database. The maximum number of characters I am allowed to use for a VARCHAR variable (and therefore also a CHAR) with Access is 255. This is a bit restrictive. The 'Memo' data type in Access would be a better choice. Is there any way to do this in SQL? If not, are there any other suggestions you could give with regards to a larger data type for strings?

TIA.

 

[Cagliostro]

create table z(a long,b memo) John Fill

http://ournet.md/~ifilipski/1c.bmp

ivfmd@mail.md