Config or Installation Issue
Data contained in a varchar type field, produces an error that avoid saving a record because de data contains characters (scape sequences) that prints Spanish language accents since the fields of any table shall contain information in Spanish and some English words or short expression(s) in the same piece of data. I think it it a config issue, because the same application, but using MSSQL as data base engine, accepted the string data as it came from the comma delimited source as is in the sequential (text) file. This is the SQL instruction and error message:
Insert INTO prodfarm (Codigo_Prod, Nombre, Prin_Activo, Forma_Farma, Activ_Terap, No_Reg_SSA, Fecha_Revision, Presentaciones, Caducidades ) Values (
'REG-0135', 'Evastel D', 'Ebastina 10 mg / Pseudoefedrina 120 mg', 'Cápsulas liberación prolongada', 'Anti-histamínico, Descongestivo', '622M98 SSA II', '2005-10-03', 'Caja con 10 y 5 cápsulas en envase de burbuja', '36 MESES' );
Error Code: 1366. Incorrect string value: '\xC3\xBApsul...' for column 'Presentaciones' at row 1
The weird thing is that other fields as Activ_Terap accepts accented words(histamínico) and allows the record to be saved, but the field Presentaciones does not.
Can anyone help me to solve this issue? I will appreciate a lot!
As a work around, I replaced the accented vowel character with a non accented one, i.e. cápsula is replaced with capsula. The record could be stored but it's a miss spelling.
Thank you.