Truncated MySQL Values

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
THEMADGEEK
Forum Newbie
Posts: 21
Joined: Thu Oct 30, 2003 6:04 pm

Truncated MySQL Values

Post by THEMADGEEK »

I am building a database and am currently having a time with the output being truncated. If I look in the database itself everything is great but when I do any output it truncates at any space.

For instance the field full_name has 'Joe User' and gets returned as 'Joe' or phone numbers get returned as '(555)' instead of the whole number. I've checked field lengths and field types everything is VARCHAR and lengths are correct.

What else could be causing this? Any ideas?

THEMADGEEK
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

If it's ok in the database, maybe something is going screwy with the code to retrieve and/or display it. Could we see that code please.

Mac
Post Reply