Hello, I've been looking into an issue that a few of our programmers have looked at as well and it left us all wondering. Basically, our database has a VARCHAR column that has an XML file written to it when the object is manipulated. I can use a tool to view the database file and I can ensure that the entire field is filled out correctly and the XML is correctly formed.
The field in the database contains 8955 characters and when I execute the sqlite3_column_text() on that specific column to access the data, the const unsigned char* that's returned only contains 2030 characters and the XML file that I'm trying to reconstruct from it then becomes unusable. I even attempted digging into the SQLite class and it seems that this value is obtained from the official function calls. In sqlite3.c: static Mem *columnMem(sqlite3_stmt *pStmt, int i){ Vdbe *pVm; int vals; Mem *pOut; pVm = (Vdbe *)pStmt; if( pVm && pVm->pResultSet!=0 && i<pVm->nResColumn && i>=0 ){ sqlite3_mutex_enter(pVm->db->mutex); vals = sqlite3_data_count(pStmt); pOut = &pVm->pResultSet[i]; After the last line has been executed pOut contains members z and zMalloc which both contain the same memory location that points to the char* that contains the first 2030 characters and none of the rest that are stored in the VARCHAR field. Is there some limit to the amount of data that can be returned by this function? I read over most of the documentation and didn't see it mentioning any sort of restriction. Thanks in advance, --Jake ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mastercam.com ********************************************************************** _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users