SQL server char field length

[kkg]

Hi!

I am facing problem with data whose length is more than 254 characters. I am using char datatype. Even if i increase the length of the field to more than 254, data with more than 254 characterscan can not be saved.

How I can save data with more than 254 characters in char field?

I will be waiting for your solution/suggestion.

Thanks in advance
Kamran Khan
kamran_khan1@netsolpk.com

 

[culshaja]

How are you presenting this data to the server. Char can cope with field sizes of up to 8,000 characters.

James
James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

 

[foxdev]

Kamran, what version of SQL Server are you using? And, as James asked, what are you using to feed the data to SQL Server?

Robert Bradley

http://www.foxdev.com/

 

[kkg]

Hi

Thanks for your responses.
I am using SQL server 7.0. Even if I give SQL command in Query Analyzer to insert/update value in char field more than 254 length. The data is trancated to 254.

I am using Power Builder 7.0 as a Front end tool.

Waiting for your reply again
Kamran Khan

 

[fluteplr]

If powerbuilder is using ODBC to connect to SQL server, make sure you are using the latest version of the ODBC drivers. Some of the earlier drivers had a bug which prevented sending more thant 255 characters to a text or long character field.