Hi @carmel.ron
What you are seeing is not the default behavior of the JDBC driver for Salesforce however this could happen when changing the configuration settings on how to represent certain columns. To be more specific, you can get the data for the Name column in JSON format when setting the following hidden connection properties in Other:
Other=AggregateCompoundFields=True;AggregateCompoundFieldsFormat=JSON;
Can you confirm if you have set these properties in your connection configuration?
Either way, if you don't want to get the data for these type of columns in JSON format you can set the AggregateCompoundFieldsFormat to NONE as below:
Other=AggregateCompoundFields=True;AggregateCompoundFieldsFormat=NONE;
In case that making these changes does not change the behavior we might need to investigate further on the matter. Feel free to reach out to our support team at [email protected] or submit a support ticket here.