help with general design of application

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

the web app that im creating will allow a user to input their email address,
and a "story" (for lack of a better term).

i have no way of knowing if this story will be 2 words or thousands of
characters. i imagine i would put some kind of limit on the field at some
point so that people couldnt go crazy, but my question is how best to store
this data?

im playing around with both SQL 2005 Express and Access for different
reasons, and from what I can see if I define a text field in Access its
limited to 255 characters. this wont be enough, so how would i want to do
this? is a database a good choice for storing this type of data? i guess i
could store only the email address in a database and then have a field that
points to a text file on the server that would store the "story", but i
would end up having a text file for every email address which might get
crazy...

whats the best way to do this?


.

Relevant Pages

  • Re: storing data in a desktop app
    ... thought of doing it as a web app with hsqldb to store data.Then,when ... application to users who will have no knowledge about database systems ... If not then use an embedded Java database (HSQLDB, H2, ...
    (comp.lang.java.programmer)
  • Re: Does Access store its data in fixed length or variable length rows
    ... Of course it may not even store all of ... Make a copy of the database. ... the process on the second telling it to save a long value, say 200 characters. ... Close and compact both. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: help with general design of application
    ... but id still like opinions on how best to do this ... limited to 255 characters. ... could store only the email address in a database and then have a field ...
    (microsoft.public.inetserver.asp.db)
  • Re: Unicode characters length (NOT size)
    ... I have a database table column in MySQL which can store up to 100 ... The encoding used in the database is UTF-8. ... store 100 characters regardless if they are single bytes or ... they are already encoded in UTF-8 ...
    (comp.lang.c)
  • Re: Unicode characters length (NOT size)
    ... I have a database table column in MySQL which can store up to 100 ... The encoding used in the database is UTF-8. ... store 100 characters regardless if they are single bytes or ... they are already encoded in UTF-8 ...
    (comp.lang.c)