What sql data type to use

[VIEW]

Hi

I've used Access to model a new database that now needs to be created in SQL Server Express.

Wow - that's alot of data types!

Can someone tell me what the SQL version of the Access Memo data type is?

Thanks
_________________
bat control (http://www.vamoosevarmint.com) free windows registry cleaner (http://www.freefixit.net)

[1849]

I'm not quite following what you are asking here. If you're asking what versions of MySQL support the MEMO field data type the answer is that all hosting providers are using versions of MySQL that support it. MySQL supports it using the TEXT data type and there are four different types:

TinyText
Text
MediumText
LongText

If that is not what you are asking, I'm sorry I mis-understood your question.

RalphF
Affordable VPS Hosting
http://www.1849webhosting.com