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-issue-importer opened this issue Nov 24, 2013 · 8 comments
Closed

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 5, 2015

Commented by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 5, 2015

Commented by: Nick (nick)

Work the same.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 5, 2015

Modified by: @dyemanov

Version: 2.5.4 [ 10585 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 10, 2015

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 10, 2015

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 RC 1 [ 10584 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 10, 2015

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 10, 2015

Commented by: @asfernandes

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 23, 2015

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