Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Column type char created as nchar on IDS 7

Status
Not open for further replies.

pamac

IS-IT--Management
Apr 11, 2002
3
GB

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top