> Hi!
> 
> Debugging CORE-4213, I found that ALTER DOMAIN uses the default database
> charset.
> 
> -- Database default charset is WIN1252.
> 
> -- OK: Domain is created with WIN1252.
> create domain d as varchar(10);
> 
> -- OK: Charset of domain is changed.
> alter domain d type varchar(10) character set utf8;
> 
> -- Not OK: Charset of domain is changed to WIN1252 (NONE if there is no
> default charset)
> alter domain d type varchar(10);
> 
> IMO, this is error prone. When one is altering the column length, it's
> easy to miss the charset and change it without knowing.
> 
> Comments?

    I agree with you - if character set is not specified at statement it should 
be left as is.

Regards,
Vlad

------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. Consolidate legacy IT systems to a single system of record for IT
2. Standardize and globalize service processes across IT
3. Implement zero-touch automation to replace manual, redundant tasks
http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to