Data extraction from mysql Ver 8.0.32 for Linux on x86_64

[Bruce Young]

Hi all,

any ideas on a resolution.

I am linking data from a mysql database into a SQL Server database.

On the SQL Server side I get:
Starting PROCEDURE [sugar].[sp_CDR_refresh_sugar_CQU_APPLICATION_CSTM] at Feb 28 2024 4:11PM
Msg 7347, Level 16, State 1, Procedure sugar.sp_CDR_refresh_sugar_CQU_APPLICATION_CSTM, Line 31 [Batch Start Line 0]
OLE DB provider 'MSDASQL' for linked server 'SUGARCRM' returned data that does not match expected data length for column '[MSDASQL].cqu_event_id_c'. The (maximum) expected data length is 72, while the returned data length is 68.

Completion time: 2024-02-28T16:12:24.4722260+10:00

Bogus error as 68 is smaller than 72, yet the error suggests its too big.

On the mysql side I see that that column is only 36 at maximum. Now 72 is fine as there can be differences.
mysql> select max(char_length(cqu_event_id_c)) from cqu_application_cstm;
+----------------------------------+
| max(char_length(cqu_event_id_c)) |
+----------------------------------+
| 36 |
+----------------------------------+
1 row in set (2.41 sec)

But how do I get the data accross?