INSERT INTO employees_x_departments(
FROM d_view WHERE employee_id IS NOT NULL
The problem is that the DepartmentRateType is a STRING and the employees_x_departments_pay_type field is an ENUM
When I run the above, everythign works good except I get empty strings for the employees_x_departments_pay_type field. When I run just the select portion of the above, I get values that match the ENUM values. Can anyone see what I am missing here?
My Field had a '\r' character in it (it camr form a csv file that was generated by excel). When I was trying to check it for line breaks during my initial test, I checked for '\n' and ' ' and '\r\n' but never '\r' by itself.