Results 1 to 4 of 4

Thread: memo vs alpha

  1. #1
    Join Date
    May 2003
    Location
    Edmonton Alberta Canada
    Posts
    41

    Unanswered: memo vs alpha

    First of all, this is the first paradox database I worked in my life.

    Secondly, I know this is going to sound stupid to you experts out there. But strangely enough, it's hard to find a good tutorial/ref on this thing.

    My question is: what is the difference between alpha and memo? Why would you use one not the other? And which type corresponds to Oracle's varchar2?

    Thanks a lot!

  2. #2
    Join Date
    Oct 2003
    Posts
    107
    No such thing as a silly question. An alpha field is limited to 255 characters. A memo (or formatted memo) is a BLOB and does not have the limitations. The memo fields are a pain to export and in some cases can cause erratic report behavior if a stray odd character gets imbedded in them when someone pastes in something from a word processor.

  3. #3
    Join Date
    Oct 2003
    Posts
    706

    Lightbulb

    Also, you can't query the contents of a memo-field. For example, you can't find occurrences of the word "XYZZY" or "PLUGH" in a memo-field, but you can in Alpha.

    (Well, you can write a twisty little script to do it, but that's a real Adventure...)
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  4. #4
    Join Date
    Oct 2003
    Posts
    107
    Also, you can't query the contents of a memo-field. For example, you can't find occurrences of the word "XYZZY" or "PLUGH" in a memo-field, but you can in Alpha.

    Mike, I never had any trouble querying memo fields. What problems have you experienced?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •