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

 

On 24-11-2016 11:02, Si Carter s1cart3r@gmail.com [firebird-support] wrote:
> 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?

Blobs themselves don't have limits (or at least: the limit is orders of
magnitude greater), but string **literals** do have limits. Instead of
having the value in the query itself, you will need to parameterize the
query, populate a new blob and execute the query with that blob as the
parameter.

Mark
--
Mark Rotteveel

__._,_.___

---

Posted by: Mark Rotteveel <mark@lawinegevaar.nl>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

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

.

__,_._,___