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
can create database with invalid character set [CORE4277] #4601
Comments
Commented by: @dyemanov Does it work the same on v2.5 or is this a v3-only issue? |
Commented by: Nick (nick) Work the same. |
Modified by: @dyemanovVersion: 2.5.4 [ 10585 ] |
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 RC 1 [ 10584 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Not enough information Test Details: Could not reproduce neither in 2.5.4 nor in 3.0 Alpha1. SQL> create database 'localhost/3254:C:\MIX\firebird\oldfb254\bin\test254.fdb' default character set win1251; ------------------------------------------------ SQL> create database 'localhost/3298:C:\MIX\firebird\oldfb30a1\test3a1.fdb' default character set win1251; |
Commented by: @asfernandes The case is about wrong charset in dbp, not right one in CREATE DATABASE. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Nick (nick)
With isc_dpb_set_db_charset = 'WIN2151' database normally created.
And i can normally create tables with varchars if define charset for fields.
But I can't create varchar field with default charset.
Commits: 1f6811a FirebirdSQL/fbt-repository@937fce6
====== Test Details ======
Could not reproduce neither in 2.5.4 nor in 3.0 Alpha1.
SQL> create database 'localhost/3254:C:\MIX\firebird\oldfb254\bin\test254.fdb' default character set win1251;
SQL> create table test1(s varchar(10) character set win1251);
SQL> create table test2(s varchar(10));
SQL> show version;
ISQL Version: WI-V2.5.4.26856 Firebird 2.5
Server version:
Firebird/x86/Windows NT (access method), version "WI-V2.5.4.26856 Firebird 2.5"
Firebird/x86/Windows NT (remote server), version "WI-V2.5.4.26856 Firebird 2.5/tcp (csprog)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.4.26856 Firebird 2.5/tcp (csprog)/P12"
on disk structure version 11.2
------------------------------------------------
SQL> create database 'localhost/3298:C:\MIX\firebird\oldfb30a1\test3a1.fdb' default character set win1251;
SQL> create table test1(s varchar(10) character set win1251);
SQL> create table test2(s varchar(10));
SQL> show version;
ISQL Version: WI-T3.0.0.30566 Firebird 3.0 Alpha 1
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30566 Firebird 3.0 Alpha 1"
Firebird/Windows/Intel/i386 (remote server), version "WI-T3.0.0.30566 Firebird 3.0 Alpha 1/tcp (csprog)/P13"
Firebird/Windows/Intel/i386 (remote interface), version "WI-T3.0.0.30566 Firebird 3.0 Alpha 1/tcp (csprog)/P13"
on disk structure version 12.0
SQL> show table test1;
S VARCHAR(10) Nullable
SQL> show table test2;
S VARCHAR(10) Nullable
The text was updated successfully, but these errors were encountered: