large scale of data.

janlie87 · #1 (**permalink**) 03-21-08, 06:04

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 .

shammat · #2 (**permalink**) 03-21-08, 08:28

The ANSI datatype would be CLOB, not sure what this is called in MySQL.
Check out the manual

r937 · #3 (**permalink**) 03-21-08, 09:20

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

shammat · #4 (**permalink**) 03-21-08, 10:04

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)

r937 · #5 (**permalink**) 03-21-08, 10:09

Quote:

Originally Posted by shammat

You have an error in your SQL syntax;

now you're sure

janlie87 · #6 (**permalink**) 03-21-08, 12:22

what can i use then???

r937 · #7 (**permalink**) 03-21-08, 12:25

Quote:

Originally Posted by janlie87

what can i use then???

what options did you find on that page?

janlie87 · #8 (**permalink**) 03-28-08, 06:57

there's no CLOB in Sql 2005 or even in SQL 2000

shammat · #9 (**permalink**) 03-28-08, 08:25

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.

aschk · #10 (**permalink**) 03-28-08, 08:31

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) ?

koriba · #11 (**permalink**) 03-31-08, 14:16

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.

Pat Phelan · #12 (**permalink**) 03-31-08, 21:20

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

Internet Services

Web Development

Digital Marketing

Consumer Tech