Hi
Running Informix Dynamic Server 7.31
I create the following table using SQL Editor 3.1, and for some reason the product_id is set to nchar and not char??
CREATE TABLE prod_safety
( product_id char(6),
product_cat char(20),
primary key (product_id));
Anyone come across this before ?
I need to add a foriegn key constraint to this table and the existing column referenced is char.