On 09/13/13 12:18, Vlad Khorsun wrote:
>> 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.
>

+1


------------------------------------------------------------------------------
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