This content has been marked as final. Show 1 reply
Once you query the column through the gateway the column is mapped to an Oracle equivalent based on the ODBC data types being returned for the column. The mapping is described in the manual:
Oracle® Database Gateway for ODBC
11g Release 2 (11.2)
=> Appendix A Data Type Conversion
So there's no way to change the mapping for a certain column unless you change the data type on the source side. So best would be if you could change the mapping to varchar, but the risk is that you might loos some data.
So what you can do is you can define on the MySQl server side a view that splits the text column into separate chunks (substr) and instead of selecting now from the table directly use the view with the chunks for this column.