Re: MySQL text field lengths truncated

Bill Saffin wrote:

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?

How are you accessing the MySQL server? What does your connection
string look like? What kind of field are you trying to use (in your
app, not in the MySQL server)?

--
Best regards :)

Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages