Home Zeos and/or SQLite crashing with Memo
Reply: 0

Zeos and/or SQLite crashing with Memo

user7800 Published in September 20, 2018, 12:44 pm

I have a VARCHAR2 Field of 10,000 Bytes and during the initiating process Zeos crashes with invalid data size. Stepping through it, the Size in question, Zeos shows 4,223,943 which I would agree, should be invalid.

Currently it appears that SQLite will not store more than 255 Bytes in a memo and now Zeos will not let me have a 10,000 VARCHAR2.

I tried with 5000 and it worked OK, but I needed more.

Should I look at something other than SQLite?

Thoughts and suggestions please.

Thanks (using D5)

share|improve this question
  • 1
    Please edit your question to post the DDL (CREATE TABLE) statement used to create a similar table. It would be helpful if we knew what you meant by "initiating process", the exact error message you're getting, and what you're "stepping through** and exactly what "Size in question" is referencing. "Should I look at something other than SQLite?" is also not an answerable question here - what you should look at is your decision to make. We can try and help you solve this problem, but not until you clearly tell us what it is first. :-) – Ken White Mar 22 '13 at 2:30
  • @KenWhite Just for information: AFAIK in SQLite3, the CREATE TABLE statement defines only some "column affinity", no exact type. You can put and read in fact any kind of data to/from a SQLIte3 column. And in SQLite3, TEXT columns have no size limit: CHAR 10, VARCHAR2 10000 or CLOB are in fact interpreted as TEXT, i.e. unlimited Unicode chars. With no speed penalty. In fact, in modern hardware, using fixed-size records is a space waste and a performance penalty - today's HW is not the same as the dBase/Paradox's time! – Arnaud Bouchez Mar 22 '13 at 8:11

1 Answer 1

active oldest votes
up vote 2 down vote accepted
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.779705 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO