Issue Details (XML | Word | Printable)

Key: CORE-4277
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Adriano dos Santos Fernandes
Reporter: Nick
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

can create database with invalid character set

Created: 23/Nov/13 10:37 PM   Updated: 23/Sep/15 11:20 AM
Component/s: Charsets/Collation
Affects Version/s: 3.0 Alpha 2, 2.5.4
Fix Version/s: 3.0 RC1

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


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 05/Jul/15 10:52 AM
Does it work the same on v2.5 or is this a v3-only issue?

Nick added a comment - 05/Jul/15 01:34 PM
Work the same.

Adriano dos Santos Fernandes added a comment - 10/Jul/15 08:08 PM
The case is about wrong charset in dbp, not right one in CREATE DATABASE.