On Mon, 24 Nov 2003 08:49:59 +0100
"Daniel Aut" <daniel.aut@...> wrote:

> Hi,
> I think the columns must be same datatype.
> id1 -> integer
> fk2 -> char(5)!!!!
>

Thanks, Daniel. My point was that the engine accepted them when they *were* different. Obviously, they *should* be the same but it seems that it is a legal (ie. no errors are reported) construction to have them unmatched.

This seems odd to me, and I was wondering if it ws by design, or an issue?

Andrew Gough