I have to create a table in which one of the fields is CITY of datatype CHAR(15).....and I have to use some sort of compressing the alphabetic field CITY ......how do I compress the field while creating it...please help me on this?
ok...i will explain what i require....
I need to create an employee table named "EMPLOYEEDET" with the following characteristics
COLUMNNAME DATATYPE LENGTH REMARKS
dept_id numeric 4 foreign key which refers the
corresponding column in the
parent table "DEPARTMENT"
emp_no numeric 4 primary key
firstname alphabetic 15
lastname alphabetic 15
city alphabetic 15 use some sort of compressing the
alphabetic field city
gender alphabetic 1 gender should be M or F.it should not
allow to enter any other character
other than M and F
age NUmeric 4
salary numeric integer:8
doj date 10
now i just have to create the table with following remarks being followed but i am not able to understand the remark of the city field. what does it mean?
what i did next to go forward was first i created the table with city fields datatype as CHAR and later on altered the table by changing the datatype from CHAR TO VARCHAR which I think will occupy less space then CHAR.Suggest me if I am wrong.