| Subject | Blob Sub Type 1 and character limits with UTF8 |
|---|---|
| Author | Si Carter |
| Post date | 2016-11-24T10:02:20Z |
Hi,
Using FB3 on windows I get the error message:
String literal with 30465 characters exceeds the maximum length of 16383 characters for the UTF8 character set
As a test I created a new db (UTF8) with the following table
CREATE TABLE WS_CUSTOM_PAGES
(
ID Bigint NOT NULL,
PAGE_DATA Blob sub_type 1,
CONSTRAINT PK_WS_CUSTOM_PAGES PRIMARY KEY (ID)
);
When inserting a record I get the following error:
Message: isc_dsql_prepare failed
SQL Message : -104
can't format message 13:896 -- message file C:\WINDOWS\SYSTEM32\firebird.msg not found
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
String literal with 30465 characters exceeds the maximum length of 16383 characters for the UTF8 character set
Have tried googling but no success and not sure if this is a limitation or not?
any help appreciated
Si