MS SQL field length > 10000 chars ??

[adrian_quah]

Hi guys, how can i use a field with a length that can store up to 10000 (ten thousand) characters?

What data type do u recommend? Any other tips?

i m using MS SQL server.

Thanks lot guys! happy weekend all!

[adrian_quah]

i tried using 'text' data type:

and i got this info from the Net:
text, 2 billion bytes of data, Actual size rounded up to the nearest 8K

how do i make it able to accept more than 8000 chars? Thanks man.

[adrian_quah]

The MS SQL help further says this:

"text

Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size may be less than 2,147,483,647 bytes.
"

but how do i go abt this to make the Field actually use the maximum length. currently, they allow only 4096 chars. ?

[adrian_quah]

Got it!!!!!!!!!!!

Used:

$a="
DECLARE @FOO1 VARCHAR(8000);
DECLARE @FOO2 VARCHAR(8000);


SELECT
@FOO1 = SUBSTRING(SUPPORT_CASE, (08000) + 1, 8000),
@FOO2 = SUBSTRING(SUPPORT_CASE, (18000) + 1, 8000)
FROM CUSTOMER_SUPPORT

PRINT @FOO1;
PRINT @FOO2;

but how do i print @FOO1 in PHP? Thanks!!!!!!!!!!

[TheIceman5]

hey dood, u might wanna try using the edit button next time dimwit.

[adrian_quah]

Iceman, pls provide an explanation thts more detailed and addresses the issue.