[firebird-support] Blob Sub Type 1 and character limits with UTF8

 

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

__._,_.___

---

Posted by: Si Carter <s1cart3r@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 6

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___