SQL Server Datatype

[Feras_86]

Dear Guys
I have an Access database file, and i want to convert it into SQL Server.. well there is a column in it which its type is Memo ( one of the record contains more than 1500 character). what is the equivalent type of memo in SQL Server??
Best Regards
Feras

[Newsgroup_User]

It's "ntext" as far as I'm aware.

Nath.

"Feras_86" <webforumsuser@macromedia.com> wrote in message
news:ej3ed1$ola$1@forums.macromedia.com...
> Dear Guys
> I have an Access database file, and i want to convert it into SQL
> Server..
> well there is a column in it which its type is Memo ( one of the record
> contains more than 1500 character). what is the equivalent type of memo in
> SQL
> Server??
> Best Regards
> Feras
>

[Newsgroup_User]

TEXT for ANSI, NTEXT for Unicode. Only use Unicode if you need to support
extended character sets.

"Feras_86" <webforumsuser@macromedia.com> wrote in message
news:ej3ed1$ola$1@forums.macromedia.com...
> Dear Guys
> I have an Access database file, and i want to convert it into SQL
> Server..
> well there is a column in it which its type is Memo ( one of the record
> contains more than 1500 character). what is the equivalent type of memo in
> SQL
> Server??
> Best Regards
> Feras
>

[Feras_86]

thx guys 🙂