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

Jump to bottom

Incorrect "string right truncation" error with NONE column and multibyte connection charset [CORE2651] #3058

Closed
firebird-automations opened this issue Sep 30, 2009 · 11 comments
Closed

Incorrect "string right truncation" error with NONE column and multibyte connection charset [CORE2651] #3058

firebird-automations opened this issue Sep 30, 2009 · 11 comments
Assignees
@asfernandes
Labels
affect-version: 2.5 Beta 2 component: charsets/collation fix-version: 2.5 RC1 priority: major qa: done successfully type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @ibprovider

Is related to QA417

[30.09.2009 17:38:27] [info] Server Name :Firebird
[30.09.2009 17:38:27] [info] Server Version :2.5.0.25593
[30.09.2009 17:38:27] [info] Client Name :Firebird SQL Server
[30.09.2009 17:38:27] [info] Client Version :2.5.0.25593
[30.09.2009 17:38:27] [info] Database ODS :11.2
[30.09.2009 17:38:27] [info] Database Dialect:3

----------
1. Connection charset: NONE

create table TEST_NONE
(
VARCHAR_1 VARCHAR(1) CHARACTER SET NONE
);

insert into test_none values (ascii_char(1));

2. Connection charset: CP943C

select * from TEST_NONE;

ERROR: arithmetic exception, numeric overflow, or string truncation. string right truncation

Same problem with GB18030 connection charset

----
With WIN1251/BIG_5 connection charsets - no any problem
@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Please test a latest snapshot.

I commited a fix yesterday.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 RC1 [ 10362 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

summary: NONE column and ICU connection charset => Incorrect "string right truncation" error with NONE column and multibyte connection charset

@firebird-automations
Copy link
Collaborator Author

Commented by: @ibprovider

Update all FB sources

[30.09.2009 19:25:57] [info] Server Name :Firebird
[30.09.2009 19:25:57] [info] Server Version :2.5.0.25641
[30.09.2009 19:25:57] [info] Client Name :Firebird SQL Server
[30.09.2009 19:25:57] [info] Client Version :2.5.0.25641
[30.09.2009 19:25:57] [info] Database ODS :11.2
[30.09.2009 19:25:57] [info] Database Dialect:3

1. Connection charset: GB18030

bad parameters on attach or create database
CHARACTER SET GB18030 is not defined

2. Connection charset: CP943C

Works with out problem.

???

@firebird-automations
Copy link
Collaborator Author

Commented by: @ibprovider

Hm

x64 work with GB18030 without problem.

Ok. This is my unexpected problem with 32-bit binaries

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Did you rebuild ICU and updated fbintl.conf?

@firebird-automations
Copy link
Collaborator Author

Commented by: @ibprovider

Ooooo.

I stupid :)

Problem was linked with old fbintl.conf

Many thanks

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA417 [ QA417 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Test added.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

Test Specifics: [Architecture (SS/CS) specific]

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

@asfernandes asfernandes

Labels
affect-version: 2.5 Beta 2 component: charsets/collation fix-version: 2.5 RC1 priority: major qa: done successfully type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@asfernandes @firebird-automations