01.04.2011 8:48, Dmitry Yemanov wrote: > I believe we need to brainstorm this. Should we rollback all these > fixes? Should we allow them but add the proper consistency checks, e.g. > allow ASCII->any-single-byte-or-utf8 and any->UTF8 conversions and > disallow everything else? Should we add a DFW job to validate the > existing data like we did for NOT NULL? Any other suggestions?
IMHO, dfw job would be better. Users may expect that they are allowed to change charset from utf8 to ascii if they are sure that there is no non-ascii chars in column. Actually, I don't understand why this job is deferred. If DDL is impossible, user must be informed about this fact ASAP. AFAIK current code, indexes will be rebuilt automatically because new type doesn't match old one. -- SY, SD. ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
