I need to convert some fields from Character type to Character (binary) using Alter Table so they can hold passwords. I can't seem to find any reference to this code anywhere. I can do it with Modify Table but I need to send out an update that does it on the run.

Anyone know how to do this? Following code returns Syntax Error.

Thanks

alter table stuff ;
alter column c1 character binary(30) ;
alter column c2 character binary(30)