New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Make possible to alter the default database character set without manual update of system table [CORE2777] #3168
Comments
Modified by: @asfernandesFix Version: 3.0 Alpha 1 [ 10331 ] Component: Engine [ 10000 ] assignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @pcisarstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 1 [ 10331 ] => |
Modified by: @dyemanovFix Version: 3.0 Alpha 1 [ 10331 ] |
Commented by: @pavel-zotov Was it intentionally done that new character set take effect only for NEW attachments ? Consider the following script (correct values in 'shell del ...' and 'create database' statements to yours): shell del C:\MIX\firebird\QA\fbt-repo\tmp\c2777.fdb 1>nul 2>&1; drop user admin2; set list on; create or alter view v_table_field_cset as set term ^; end -------------------------- main phase -------------------------- create table old_att_init(text_init varchar(10)); select * ------------------------------------------------------------------ alter database set default character set utf8; -- Make new table with default charset = UTF8 using the SAME select * -- Now try to create table with default charset = UTF8 using NEW attachment: select * ------------------------------------------------------------------ alter database set default character set win1250; -- Make new table with default charset = WIN1250 using the SAME select * -- Now try to create table with default charset = WIN1250 using NEW attachment: select * ------------------------------------------------------------------ alter database set default character set dos866; create table old_att_d866(text_d866 varchar(10)); -- Make new table with default charset = DOS866 using the SAME -- Now try to create table with default charset = dos866 using NEW attachment: select * ------------------------------------------------------------------ -- Make new table with default charset = WIN1252 using the SAME select * -- Now try to create table with default charset = WIN1252 using NEW attachment: select * When I run this script on WI-T3.0.0.31780 then result is evidence that new charset will be seen only for NEW attachment (which is done by ES EDS when calling sp_create_table) -- please see it in attached file. |
Modified by: @pavel-zotovAttachment: core-2777.log.zip [ 12702 ] |
Commented by: @asfernandes It's not expected, please create a proper ticket for it. And please, in this new ticket, mention also that the character set passed in alter database is not being validated to be an existing one. |
Commented by: @pavel-zotov > create a proper ticket for it |
Submitted by: @asfernandes
Is related to QA649
Attachments:
core-2777.log.zip
Add ALTER DATABASE ... SET DEFAULT CHARACTER SET ...
Commits: ad4d4b2
The text was updated successfully, but these errors were encountered: