Forums
This topic is locked
SQL Data Types
Posted 13 Jul 2001 23:34:24
1
has voted
13 Jul 2001 23:34:24 Viktor Farcic posted:
When I use ntext or text as data type in SQL Server I can't display it on page. Like that there's no data in that field. When I change data type to something else (nvarchar...) same page works and shows data. What am I doing wrong?
Replies
Replied 15 Jul 2001 00:41:37
15 Jul 2001 00:41:37 Joel Martinez replied:
I always use varchar as my datatype in SQL server... int for numbers... it hasn't failed yet.
Joel Martinez
----------
Is this thing on?....
Joel Martinez
----------
Is this thing on?....
Replied 15 Jul 2001 01:02:15
15 Jul 2001 01:02:15 Viktor Farcic replied:
What if you don't know how many characters will be in some field? In my case, there can be few thousands characters.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I always use varchar as my datatype in SQL server... int for numbers... it hasn't failed yet.
Joel Martinez
----------
Is this thing on?....
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I always use varchar as my datatype in SQL server... int for numbers... it hasn't failed yet.
Joel Martinez
----------
Is this thing on?....
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 15 Jul 2001 03:39:24
15 Jul 2001 03:39:24 Joel Martinez replied:
well, if I'm not mistaken, the varchar will only take up the space it needs, so if you put it at some large value, then it will only take up what it needs...
but it wont hurt to try it at least
Joel Martinez
----------
Is this thing on?....
but it wont hurt to try it at least
Joel Martinez
----------
Is this thing on?....