I am moving data from MySQL to Oracle 12c. There is a datatype called bit on MySQL side that is not recognized by MariaDB connection.
The values used in the column active are true and false.
The reader completes successfully but results show <missing>.
Best answer by nampreetatsafe
Hi @discojohnny! Looks like there's a known limitation in supporting the bit data type. I've created a support case for you so that we can link your issue with our internal development ticket (internal reference FMEENGINE-62200).
In the meantime there's a suggested workaround using the SQLExecutor in FME as mentioned by @david_r in this post: https://knowledge.safe.com/questions/58629/how-can-i-write-a-bit-value-10-to-a-bit-column-in.html. I hope this helps!
+13Hi @discojohnny! Looks like there's a known limitation in supporting the bit data type. I've created a support case for you so that we can link your issue with our internal development ticket (internal reference FMEENGINE-62200).
In the meantime there's a suggested workaround using the SQLExecutor in FME as mentioned by @david_r in this post: https://knowledge.safe.com/questions/58629/how-can-i-write-a-bit-value-10-to-a-bit-column-in.html. I hope this helps!
