In sqlite-jdbc driver(3.23 or 3.30),fail update when string is too long, without any exception. But in command line and navicat, it's OK

Question

SQL

replace into articles(id,grade,no,title,content,newchars,update_time)
values(1394823098212,'1','8','title','**LongUtf8String**',1614001996557)

If the length of LongUtf8String exceeds 2689 bytes, the operation will fail, without any exception. In sqlite command line and navicat, it can work.

Table definition: create table if not exists articles ( id long not null primary key, grade tinyint not null, no smallint not null, title varchar(255) not null, content text not null, newchars text not null );

I can't find any configuration items in SQLiteConfig.

Are there any ways to overcome the limit? Thanks!!!

score 0 · Answer 1 · answered Mar 04 '21 at 13:15

0

It is my fault:((( I limited the length when check parameters, and discard it without prompt.

answered Mar 04 '21 at 13:15

flyinmind

31
1

In sqlite-jdbc driver(3.23 or 3.30),fail update when string is too long, without any exception. But in command line and navicat, it's OK

1 Answers1