Results 1 to 12 of 12
  1. #1
    Join Date
    Dec 2007
    Location
    College Park, Maryland
    Posts
    14

    Question Unanswered: large scale of data.

    what is the equivalent type of variable MEMO in Access Database to SQL.

    i need to restore a large data..like i have a project about Legislative tracking system..and what will i used to restore the whole resulotion/bill in one variable... im using SQL as my back-end and VB as my front-end

    thanx .
    " a man that moves a mountain starts first with the little stones " - not a liar

    Janlie Macdovish
    Software Engineer
    College Park, MD

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    The ANSI datatype would be CLOB, not sure what this is called in MySQL.
    Check out the manual

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by shammat
    The ANSI datatype would be CLOB, not sure what this is called in MySQL.
    you're not sure? it's called CLOB
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Quote Originally Posted by r937
    you're not sure? it's called CLOB
    Code:
    create table clob_test
    (
      id int,
      clob_data clob
    )
    returns
    Code:
    You have an error in your SQL syntax; 
    check the manual that corresponds to your MySQL server version 
    for the right syntax to use near 'clob)'
    According to the manual there is no keyword CLOB in MySQL. MySQL lists several different TEXT types though (apparently with different max. sizes)

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by shammat
    You have an error in your SQL syntax;
    now you're sure
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Dec 2007
    Location
    College Park, Maryland
    Posts
    14
    what can i use then???
    " a man that moves a mountain starts first with the little stones " - not a liar

    Janlie Macdovish
    Software Engineer
    College Park, MD

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by janlie87
    what can i use then???
    what options did you find on that page?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Dec 2007
    Location
    College Park, Maryland
    Posts
    14
    there's no CLOB in Sql 2005 or even in SQL 2000
    " a man that moves a mountain starts first with the little stones " - not a liar

    Janlie Macdovish
    Software Engineer
    College Park, MD

  9. #9
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    As far as I know those are defined in SQL 2003 (SQL3)
    http://savage.net.au/SQL/sql-2003-2.bnf.html

    But even if they weren't defined in the standard, you can still use the datatypes that MySQL offers and which are documented in the manual.

    Read the link I posted.

  10. #10
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    BLOB or TEXT should fulfil your needs. What are you storing? It is just a bunch of characters? Or is it binary information (like an image/exe) ?

  11. #11
    Join Date
    Mar 2008
    Location
    Windhoek Namibia
    Posts
    13
    Memo is a very Accessyyyyy (MS access) thing.

    If you are storing text use the text field .. If images etc use BLOB. BLOBs are very heavy on the db server. At times using both may be the best solution depending on what you want to store AND how you want to retrieve this.
    Wayne Philip - openaxon.com

  12. #12
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Are you looking for a Microsoft SQL Server datatype? This is actually a MySQL forum, which is probably why the answers aren't helping you very much.

    I'd be happy to move the thread to the Microsoft SQL Server forum if you'd like (and give you answers better suited to that database engine too).

    -PatP

Posting Permissions

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