Re: help with general design of application

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

ok so in Access i can have a memo field... :o)


but id still like opinions on how best to do this



"Jimmy" <j@xxx> wrote in message
news:eoAlFN00GHA.4392@xxxxxxxxxxxxxxxxxxxxxxx
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: 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)
  • help with general design of application
    ... the web app that im creating will allow a user to input their email address, ... point so that people couldnt go crazy, but my question is how best to store ... limited to 255 characters. ... is a database a good choice for storing this type of data? ...
    (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)
  • Re: public and private mailboxes randomly dismounting
    ... When posting logs an important piece is the Event ID and Source. ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)