I have this sql:
CREATE DOMAIN TYPE_TIME_ZONE_ID AS VARCHAR(40);
ALTER TABLE MAIN_HEADER ADD TIME_ZONE_ID TYPE_TIME_ZONE_ID DEFAULT 'Europe/Berlin' NOT NULL;
There are already data in table, so I want to add new column (not nullable) and set it's value to "Europe/Berlin" for all exsiting rows. But when I run this, the value in solumn is only "Eur". I can't figure out, why it is cut like this.
Thanks for any idea.