🚀 go-pugleaf

Hi there!

I am writing a database application that connects to a MYSQL server using
the MYODBC provider. Most things are working okay but I am having a problem
with VarChar (and Char) fields in that they seem to be chopping off when
they reach a certain point in the string I am trying to store. For example,
if I try to store the string "what is going on?" only "what is goi" is put
into the database.

The table is of type MYISAM. I have also tried INNODB. The field is defined
as:

username VARCHAR (50)

I have tried other VarChar fields in my database and they all seem to have
the same problem. The code I am using to set and post the String is as
follows:

String DBTest = "what is going on?";
tblUsers->Insert();
tblUsers->FieldByName("username")->AsString = DBTest;
tblUsers->Post();
String DBCheck = tblUsers->FieldByName("username")->AsString;

In the above example, DBCheck evaluates as "what is goi".

I have also tried placing a check right after I assign the field to DBTest,
before posting the value, and at this stage the value in the field is also
just "what is goi". I assumed the (50) in the field definition indicated a
length of 50 characters but incase I was wrong, I changed the length to 150
and then 200. This did not solve the problem. I used the following sql on
the server to change the length:

alter table tblUsers modify username VarChar(200);

My ADOTable has no persistant field defs. At this stage I'm not sure what is
causing the problem or how it can be fixed. Any insights into what I am
doing wrong would be appreciated.

Thankyou,
Jason Shrapnel
Invarion Pty Ltd