MongoDB ODBC / SQL Server - query results showing truncated fields
Posted: Thu 31 May 2018 11:43
Hello,
I am a demo user of the MongoDB ODBC driver, prior to purchase it if working, which is not fully the case so far...
I have configured from my sql Server instance a Link server connecting to a MongoDB database through the ODBC driver.
So far OK => set-up, connection, ...
The issue is that in my Select query result (launch from SQL Server editor) I found out that some fields are showing up as truncated in the result:
- Some columns are showing result string for up to 500+ characters.
- But one colum is only displaying a maximum of 158 (?) characters.
Investigating, I found out that there was a parameter within the ODBC configuration called 'Describe amount' => aimed at giving the number of 'sample' lines to be taken into account for data characterisation (types). Default to 25.
My first analysis was that the max size of the column was also determined as per a sample of 25 and some lines were truncated due to the fact that this sample is not showing long enough lines
=> So I have changed it to 200, then 500, then 100, then more than the total of lines in the source DB: no effect.
I have still some lines truncated, with the part kept being very limited (not talking about fieds with thousands of chars)
Any idea on how to fix this ?
Thanks in advance !
I am a demo user of the MongoDB ODBC driver, prior to purchase it if working, which is not fully the case so far...
I have configured from my sql Server instance a Link server connecting to a MongoDB database through the ODBC driver.
So far OK => set-up, connection, ...
The issue is that in my Select query result (launch from SQL Server editor) I found out that some fields are showing up as truncated in the result:
- Some columns are showing result string for up to 500+ characters.
- But one colum is only displaying a maximum of 158 (?) characters.
Investigating, I found out that there was a parameter within the ODBC configuration called 'Describe amount' => aimed at giving the number of 'sample' lines to be taken into account for data characterisation (types). Default to 25.
My first analysis was that the max size of the column was also determined as per a sample of 25 and some lines were truncated due to the fact that this sample is not showing long enough lines
=> So I have changed it to 200, then 500, then 100, then more than the total of lines in the source DB: no effect.
I have still some lines truncated, with the part kept being very limited (not talking about fieds with thousands of chars)
Any idea on how to fix this ?
Thanks in advance !