We have a database with articles, that, IMO could be improved from a column size perspective (we have more than 170 columns)
There are lots of columns, were we only store some bools (1 or 0).
Instead of having something like COLUMN X, Z, Y, N separately, would it be more optimal to merge everything in one column, called "XZYN", with values, where each number represents the status of XZYN.

Example :
1000 would mean X= true, ZYN = false.
Of course, this state would be interpreted from our code.

Is this a good idea ?