which is the biggest string datatype in sql database ?

Question

1.00/5 (1 vote)

See more:

Hey Friends,
i used varchar(max) datatype in table but still it is small to store my string plz suggest me bigger size datatype. thank you.
my string is as follows:

"X RAY LEFT HIP WITH THIGH AP/LAT --ACCEPTABLE WITH IMPLANT IN SITU WITH ACETABULAR CUP ARTHRITIC CHANGES    2 D ECHO-MILD CONC LVH                  GOOD LV DIASTOLIC FUNCTION                    ALTERED LV DIASTOLIC FUNCTION LVEF 55 %  MRI BRAIN- FEW OLD ISCHEMIC CHNGES IN BILATERAL CEREBRAL WHITE MATTER    MRI L-S SPINE WITH SCREENING OF WHOLE SPINE- PID-L3-4,L5-S1  PID C3- 4TO C6-7  "

Posted 22-Apr-15 20:38pm

Member 11543226

Updated 22-Apr-15 21:03pm

Maciej Los

v2

Add a Solution

Comments

Sascha Lefèvre 23-Apr-15 2:45am

Which database are you talking about? SQL Server stores up to 2GB in a varchar(max) column. So that can't be the issue.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bhavikkumar Chaudhari · Answer 1 · 2015-04-22T20:56:00

Solution 1

Your string is having length = 341
varchar(max) can store upto 8000 chars.

Alternative way is to use nvarchar(max).

https://msdn.microsoft.com/en-us/library/ms176089.aspx[^]
Hope this helps.
-Bhavik Chaudhari

Posted 22-Apr-15 20:56pm

Bhavikkumar Chaudhari

Updated 22-Apr-15 21:02pm

v2

Abhinav S · Answer 2 · 2015-04-22T21:04:00

Solution 2

Your question is not very clear.
There are only three types of string types - char , text and varchar.
Both text and varchar support date lengths upto 2GB.

Nvarchar and ntext are used only for storing unicode characters.
As per documentation[^], text and ntext will be removed in a future release.

There is another type called sql_variant that can store values of various data types.

Posted 22-Apr-15 21:04pm

Abhinav S

Comments

Member 11543226 23-Apr-15 3:23am

can sql_variant able to store above string? i tried with varchar(max) and nvarchar(max) both faild.

Abhinav S 23-Apr-15 4:18am

Check the error again. It may not have anything to do with the size of the data.

Member 11543226 23-Apr-15 6:00am

i found the original problem this string is enclosed in double quotes and contain 1 quamma also. thats the issue plz give me sugessiton to solve it.

Member 11543226 23-Apr-15 6:54am

it works thanks. but the original problem is different.