Skip to content
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

Closed
firebird-automations opened this issue Nov 24, 2013 · 8 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Does it work the same on v2.5 or is this a v3-only issue?

@firebird-automations
Copy link
Collaborator Author

Commented by: Nick (nick)

Work the same.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 2.5.4 [ 10585 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 RC 1 [ 10584 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

The case is about wrong charset in dbp, not right one in CREATE DATABASE.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment