On Thursday 2002-01-31 at 01:43:57 +0100, Duilio Foschi wrote:

> I have several varchar(6) fields in my database tables where I store dates
> in the yymmdd format.
>
> One of these tables behaves strangely.
>
> When I try to write a record, I get the following error message:
>
> <overflow occurred during data type conversion. Conversion error from
> string "020131">
>
> What does it mean ?

Hi, Duilio,

I don't believe it's possible to get a data type conversion error when
storing a string into a VARCHAR. There must be something else
happening here. Could you show us a code snippet (SQL or Delphi), and
the database table definition (e.g. the result of "show table xyz;" in
the ISQL program). Perhaps the column is not of the type you expected,
or (seems more likely) Delphi is doing some conversion along the way
somewhere.

Try (if you haven't already) using a program like ISQL and enter something like:

insert into xyz (mycol) values ('020131');

Does the same message occur?

Also, how are you interfacing to FB with Delphi? Do you use IBObjects,
for instance, or are you struggling with the BDE?


Cheers,
David