Solved

SQL Server: best data type for long question

Posted on 2011-09-29
4
188 Views
Last Modified: 2012-05-12
Hi

In SQL Server 2008, which data type would be best for a field that holds
up to 1000 text characters?

Thanks
0
Comment
Question by:murbro
4 Comments
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 167 total points
ID: 36813688
nvarchar2(MAx)

Or
give size as per you requiremt

nvarchar2(1000)
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 167 total points
ID: 36813693
If your question will contain only English characters, then choose VARCHAR(1000) else choose NVARCHAR(1000).
0
 
LVL 25

Assisted Solution

by:Lee Savidge
Lee Savidge earned 166 total points
ID: 36813699
nvarchar(1000)
0
 

Author Closing Comment

by:murbro
ID: 36813779
thanks very much
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question