We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Submitted by: Alexander (sms-timing)
Is related to QA542
The update statement fails since I switched to UTF8.
update NEW_TABLE set big = :new where big is distinct from :new
Undefined name. Dynamic SQL Error. SQL error code = -204. Implementation limit exceeded. block size exceeds implementation restriction.
Included the db (ibexpert)script
SET SQL DIALECT 3; SET NAMES UTF8; SET CLIENTLIB 'fbclient';
CREATE DATABASE 'LOCALHOST:c:\test.fdb' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 8192 DEFAULT CHARACTER SET UTF8;
CREATE DOMAIN NEW_DOMAIN AS VARCHAR(8191);
CREATE TABLE NEW_TABLE ( NEW_FIELD INTEGER, BIG NEW_DOMAIN );
The text was updated successfully, but these errors were encountered:
Commented by: @asfernandes
This is well know problem. I'm not sure if it's already registered.
VARCHAR(8191) in UTF8 uses 32764 bytes.
You're using two parameters, hence 65528 bytes, and that is greater than the implementation limit.
Sorry, something went wrong.
Fix Version: 3.0 Alpha 1 [ 10331 ]
Component: Engine [ 10000 ]
assignee: Dmitry Yemanov [ dimitr ]
Component: Charsets/Collation [ 10001 ] =>
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Fixed [ 1 ]
Link: This issue is related to QA542 [ QA542 ]
QA Status: No test
status: Resolved [ 5 ] => Resolved [ 5 ]
QA Status: No test => Done successfully
dyemanov
No branches or pull requests
Submitted by: Alexander (sms-timing)
Is related to QA542
The update statement fails since I switched to UTF8.
update NEW_TABLE set big = :new where big is distinct from :new
Undefined name.
Dynamic SQL Error.
SQL error code = -204.
Implementation limit exceeded.
block size exceeds implementation restriction.
Included the db (ibexpert)script
SET SQL DIALECT 3;
SET NAMES UTF8;
SET CLIENTLIB 'fbclient';
CREATE DATABASE 'LOCALHOST:c:\test.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192
DEFAULT CHARACTER SET UTF8;
CREATE DOMAIN NEW_DOMAIN AS
VARCHAR(8191);
CREATE TABLE NEW_TABLE (
NEW_FIELD INTEGER,
BIG NEW_DOMAIN
);
The text was updated successfully, but these errors were encountered: