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

utf8 causes varchar size off by 1 sometimes [CORE3828] #4170

Closed
firebird-automations opened this issue Apr 23, 2012 · 4 comments
Closed

utf8 causes varchar size off by 1 sometimes [CORE3828] #4170

firebird-automations opened this issue Apr 23, 2012 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Joerg Fischer (jfischer)

Duplicates CORE3373

open the command prompt
C:> isql
1. SQL> create database 'localhost:c:/tmp/test.fdb' user 'SYSDBA' password 'masterkey' default charset UTF8;
2. SQL> create table test (foo varchar(10), bar varchar(30));
3. SQL> insert into test (foo, bar) values ('1234567890', '1234567890123456789012345678901');
4. SQL> select * from test;
5. SQL> insert into test (foo, bar) values ('12345678901', '123456789012345678901234567890');

The command in line #⁠3 works and creates an entry with 31 characters in a varchar(30). The command in line #⁠5 fails like expected. This error happens only if charset is UTF8.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue duplicates CORE3373 [ CORE3373 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

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

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

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

No branches or pull requests

1 participant