Reported By: Kees Lagendijk Reported On: 10/24/2003 For: Version 3.26 Build 1
# 1431SQL CREATE and ALTER TABLE Statements Not Allowing Double-Quotes for Default, Min, or Max Values Alter table add char-field refuses default value.
alter table test
add testfield char(1) default "X"
Comments and WorkaroundsThe workaround is to use single quotes instead.
ResolutionFixed Problem on 10/30/2003 in version 3.27 build 1