Hi Derrell, I checked the versions and indeed the one I'm using on Windows is 3.0.8 whether the one on Linux is 3.1.2. This being said as far as I understand and please correct me if I'm wrong the two PRAGMA(s) are just commands you run used to modify the operation of the SQLite library. I haven't invoked any of them before running the statements I mentioned so I assume the default behavior was used. How can I find what this is for the particular versions I'm running?
Thanks, Iulian. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 22, 2006 3:20 PM To: [email protected] Subject: Re: [sqlite] Different column names in callback function on Linux vs. Windows "Iulian Popescu" <[EMAIL PROTECTED]> writes: > I'm doing an application port from Windows to Linux and one of the > problems I'm facing is when executing the following statement through a call > to sqlite3_exec(): > > SELECT mytable.'mycolumn' FROM table > > The registered callback function 4th argument (a char**) denoting the column > names contains the string mytable.'mycolumn' on Windows and the string > mycolumn on Linux. Has anyone any idea why would that be? I suspect you're using different versions of sqlite on Windows and Linux, or you have pragma settings set differently on the two OSs. You can verify the version of sqlite with "sqlite3 -version". There have been changes, through the development of sqlite, on what column names to return. IIRC, the meanings of PRAGMA short_column_names and PRAGMA full_column_names have changed a couple of times, and these affect exactly the information that you're having trouble with. You should first ensure that you are running the same version of sqlite on the to OSs. Then ensure that the settings of these two pragmas are the same. With both the version and the pragma settings the same, I believe you should get the same values passed to the callback function, given the same query. Windows and Linux portations built from the same source, so should generate similar results. Derrell
