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

"String truncation" error when using "type of column" on UNICODE_FSS column, and non-UNICODE_FSS client charset [CORE2902] #3286

Open
firebird-automations opened this issue Mar 3, 2010 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Alex Bekhtin (afgm)

Votes: 1

execute block
returns (
RDB$FIELD_NAME type of column RDB$TYPES.RDB$FIELD_NAME,
)
AS
begin
for select
t.rdb$field_name
from rdb$types t
into :rdb$field_name
do
begin
suspend;
end
end

for client charset WIN1251, UTF8:
arithmetic exception, numeric overflow, or string truncation.
string right truncation.

for client charset UNICODE_FSS it works correctly

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Modified the Summary to better reflect the details of the case.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

summary: incorrect string type in "type of column" => "String truncation" error when using "type of column" on UNICODE_FSS column, and non-UNICODE_FSS client charset

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

System string fields are a hack re. size in bytes vs characters. I think there is no good way to fix that before 3.0, and nothing in this regard has been done in 3.0 yet.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 3.0 Initial [ 10301 ]

Version: 3.0 Alpha 1 [ 10331 ] =>

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