Skip to main content
Known Participant
November 11, 2006
Question

SQL Server Datatype

  • November 11, 2006
  • 2 replies
  • 373 views
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
This topic has been closed for replies.

2 replies

Inspiring
November 13, 2006
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_86Author
Known Participant
November 14, 2006
thx guys :)
Inspiring
November 11, 2006
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
>