Advertisement

05.23.2008 at 05:59AM PDT, ID: 23427394 | Points: 500
[x]
Attachment Details

SQL Server 2005 Text field too small

Asked by ncw in SQL Server 2005

Tags: , ,

I'm using MS SQL Server 2005 on a shared Windows server and connecting using Php script. I converted a MySql database into a MsSql database and I'm finding the SQL Server text field datatype is too small and is causing an error. Can anyone suggest a solution please?

I've read where it was suggested to use a blob type field instead, but I don't see blob listed. Can I use the xml datatype? Or set the text field size - I tried this but the MS Management Studio Express says the command is not supported.Start Free Trial
[+][-]05.23.2008 at 06:02AM PDT, ID: 21631663

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.23.2008 at 06:10AM PDT, ID: 21631740

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.25.2008 at 08:40AM PDT, ID: 21642948

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.15.2008 at 11:51AM PDT, ID: 22481729

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628