|
If you were logged in you would be able to see more operations.
|
|
|
|
File Attachments:
|
1.
test.cpp (4 kB)
|
|
Environment:
|
|
|
|
Step to reproduce error:
1. create a new blank database with characterset=utf8
2. create a table with one varchar(9) column.
actually 4x9=36 bytes will be automatically allocated by firebird.
3. insert one one column with 9 non-ascii utf8 (eg cyrillic
or chinese) character such that bytecount greater than 9
4. expect a data truncation error.
(ATM I cannot test firebird allocate 3 or 4 bytes for each varchar character)
|
|
Description
|
Step to reproduce error:
1. create a new blank database with characterset=utf8
2. create a table with one varchar(9) column.
actually 4x9=36 bytes will be automatically allocated by firebird.
3. insert one one column with 9 non-ascii utf8 (eg cyrillic
or chinese) character such that bytecount greater than 9
4. expect a data truncation error.
(ATM I cannot test firebird allocate 3 or 4 bytes for each varchar character)
|
Show » |
|
Bug
Closed
Major
data truncation error when inserting utf8 characters
you need to create a blank utf8 database separately.
the SQLLEN strorlen parameter is used even for this
single row example because I actually insert multiple
rows in my real code, and this parameter is needed to
provide the length of field in each row.