Web Wiz Forums - difference of text and NText data types ?

Print Page | Close Window

difference of text and NText data types ?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=17494
Printed Date: 15 April 2026 at 7:29pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: difference of text and NText data types ?

Posted By: miladanimator
Subject: difference of text and NText data types ?
Date Posted: 09 December 2005 at 9:03am

I use sql version of webwiz 7.95

is There any problem if I Convert message.tblthread & pm message.tblpmmessage data type from Text to Memo ???

and what is difference of text and memo data types in sql server ???

Replies:

Posted By: WebWiz-Bruce
Date Posted: 09 December 2005 at 11:40am

The 'Memo' field datatype is simular to the 'Text' datatype in SQL except that SQL server doesn't have a datatype of 'Memo'.

When converting Access datatypes to SQL server 'Memo' becomes 'Text'

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: miladanimator
Date Posted: 09 December 2005 at 3:55pm

oh - sorry !

My question is here :
I use web wiz forum On a Persian(Farsi) web site .
but when users insert persian data , in text data type , the persian datas convert to ????? ????? ?????? ????? ????? .
but in other types for example : ntext , nvar... , ... the persian data show correctly .

is There any problem if I Convert message.tblthread & pm message.tblpmmessage data type from Text to NText ???

and what is difference of text and ntext data types in sql server ???
Cry

Posted By: miladanimator
Date Posted: 10 December 2005 at 3:58am

OR ANY ONE CAN GIVE ME A CODE FOR sql query analayzer THAT

change the database collation name from :

SQL_Latin1_General_CP1_CI_AI

Arabic_cl_AS ???

I think this solve my problem ...

Posted By: tango
Date Posted: 10 December 2005 at 4:59pm

There is a big difference between Text an NText fields in SQL. Text fields are limited in size while NText are not. NText in SQL is the same as memo in access.