Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-25 Thread Matt Young
I used the strcpy_s function from Microsoft, the so called safe version that includes a char count. I used it under the Studio debugger. Set a buffer of 200 chars to zero, set the char count to 20 in strcpy_s, and the debugger wrote in the top 180!! I freaked, didn't see that as safe at all! On

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-25 Thread Igor Tandetnik
Matt Young youngsan...@gmail.com wrote: I used the strcpy_s function from Microsoft, the so called safe version that includes a char count. I used it under the Studio debugger. Set a buffer of 200 chars to zero, set the char count to 20 in strcpy_s, and the debugger wrote in the top 180!! As

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-24 Thread Tony McC
On Wed, 21 Dec 2011 21:33:02 + Jacob A. Camp jacob.c...@mastercam.com wrote: There it is, when I printed this value out to a txt file everything was there. Apparently there is some sort of character limit when displaying strings in debug mode in Visual Studio 2010, news to me...

[sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread Jacob A. Camp
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

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread Igor Tandetnik
Jacob A. Camp jacob.c...@mastercam.com wrote: 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 What do you mean by that?

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread nobre
Is there any chance you are storing a \0 char inside the xml ? Jacob A. Camp wrote: 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

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread Simon Slavin
On 21 Dec 2011, at 1:31pm, nobre wrote: Is there any chance you are storing a \0 char inside the xml ? Or that you are mixing 8-bit and 16-bit Unicode in such a way that one of your routines thinks that it has read a 0x00 termination character ? Simon.

[sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread Jake
Simon Slavin slavins@... writes: On 21 Dec 2011, at 1:31pm, nobre wrote: Is there any chance you are storing a \0 char inside the xml ? Or that you are mixing 8-bit and 16-bit Unicode in such a way that one of your routines thinks that it has read a 0x00 termination character ?

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread Igor Tandetnik
Jake jacob.c...@mastercam.com wrote: For the previous post asking what occurs after 2030, there's nothing What do you mean, nothing? What exactly happens when you try to access p[2030]? because the returned value is only allocated for those characters. What makes you believe this? -- Igor

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread Jacob A. Camp
returns 8960 if that's helpful. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Wednesday, December 21, 2011 10:29 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3_column_text() returning partial

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread Black, Michael (IS)
: Wednesday, December 21, 2011 9:41 AM To: 'General Discussion of SQLite Database' Subject: EXT :Re: [sqlite] sqlite3_column_text() returning partial results I have a line of code that executes that line: const unsigned char * temp2 = sqlite3_column_text(state, 0); This queries the database and after

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread Pavel Ivanov
On Wed, Dec 21, 2011 at 10:41 AM, Jacob A. Camp jacob.c...@mastercam.com wrote: I have a line of code that executes that line: const unsigned char * temp2 = sqlite3_column_text(state, 0); This queries the database and after the call is complete I pass this value to another function. This

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread Jacob A. Camp
: Wednesday, December 21, 2011 11:20 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] sqlite3_column_text() returning partial results On Wed, Dec 21, 2011 at 10:41 AM, Jacob A. Camp jacob.c...@mastercam.com wrote: I have a line of code that executes that line: const unsigned

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread Pavel Ivanov
Now, this is a very good test case and explanation what happens, except... How did you check value of CString testing after iterating though the entire char array? Did you look at it in your debugger? Maybe your debugger is not capable of showing CString contents longer than 2048 symbols? The

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-21 Thread Jacob A. Camp
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Wednesday, December 21, 2011 2:33 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] sqlite3_column_text() returning partial results Now, this is a very good test case and explanation what happens, except... How did