?
Solved

255 Character Strings?

Posted on 2002-07-23
6
Medium Priority
?
212 Views
Last Modified: 2013-12-03
Hi,

I'm told PHP has no problems with long strings, however, if I attempt to retrieve a 2000 character long string from an MS-SQL database, I'm only shown the first 255 characters of it.

Is there any reason to this at all?  How do I over come this problem?

Thanks for any help you can give,

Stu
0
Comment
Question by:Stuart_Johnson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 40

Expert Comment

by:Richard Quadling
ID: 7171466
Can you confirm that more than 255 characters are stored in the database field? What field type is being used.

There is a function you can get the type with ...

string mssql_field_type ( int result [, int offset])

So,

echo mssql_field_type($results,0);

would show the type of the first column in the result set.

You may find that the field is set to be a small text field of some type, so only 255 characters are being stored.

Try using another client to get the data out, maybe something like MSQuery or even Excel/Word via ODBC, or something, so you can see the data.

Richard.
0
 
LVL 6

Author Comment

by:Stuart_Johnson
ID: 7171715
Hi Richard,

If I do this:

  echo(mssql_field_type($result,1));
  echo(mssql_field_length($result,1));

I get Char 255 - which it's not.  It's a char(2000).

If this is the case, should I change data types on MS-SQL?  If so, what should I be using?

Thanks for the info,

Stu.
0
 
LVL 40

Accepted Solution

by:
Richard Quadling earned 400 total points
ID: 7171745
Just to confirm, can you try the that test on a result where you know the data is LESS than 255, just to make sure that the test is NOT giving you the length of the data and the length of the field.

I am not up on the text types of MSSQL, but try varchar(2000) or text(2000).


0
WordPress Tutorial 4: Recommended Plugins

Now that you have WordPress installed, understand the interface, and know how to install new parts, let’s take a look at our recommended plugins.

 
LVL 6

Author Comment

by:Stuart_Johnson
ID: 7171756
Hi Robert,

I changed the data type to text and it worked perfectly!  Thank's very much for that!

Stu.
0
 
LVL 40

Expert Comment

by:Richard Quadling
ID: 7171762
It's Richard and no problems! <grin>
0
 
LVL 6

Author Comment

by:Stuart_Johnson
ID: 7171816
Hahaha.  Sorry.  I even got it right on the first post.

Sorry!!

Stu
0

Featured Post

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

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

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses

765 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