MySQL text field lengths truncated
- From: "Bill Saffin" <bsaffin@xxxxxxxxxxx>
- Date: Fri, 20 Oct 2006 17:12:52 -0700
I'm new to MySQL development. I'm using Delphi 7, ADO components, connecting
to a remote MySQL server 4.1.10.
I've got a text field in a table in the database. When I use varchar(255)
for the type, I get 255 characters in the field. When I try other text types
(Medium Text, Long Text) with larger numbers specified (I've tried 512,
1024, 4096), I can't get more than 162 characters. I checked this by adding
fields to the query (edit the field list).
I've searched for this type of error, but can't find a solution. I can't use
a longer varchar type because the web hosting company isn't ready to move to
MySQL 5.
Anybody solve this type of problem?
.
- Follow-Ups:
- Re: MySQL text field lengths truncated
- From: Guillem
- Re: MySQL text field lengths truncated
- Prev by Date: Re: Saving Image/Picture to Database using ADO
- Next by Date: Re: TADODataset.Filter?
- Previous by thread: ADO vs dbExpress
- Next by thread: Re: MySQL text field lengths truncated
- Index(es):
Relevant Pages
|
