Re: Config or Installation Issue
Posted by: Luis Benitez-Martell
Date: April 17, 2020 02:35PM

Indeed is a character issue. That's why I believe is configuration related. Besides, I have a couple observations:

1) As you can see the nine field´s data, precisely other fields but ´
Presentaciones', the data has text with accented words. the same 'Cápsulas' piece of text holds a character 'a' accented ( á ) which was perfectly inserted and the record got saved. How come, the same word did not generate SQL error, but if left accented, to be inserted over the field Presentaciones, sends an error and the record was not created.
2) I'm porting the the same application, to use MySQL, from the original that uses an MSSQL database. It showed NO errors, and I didn't change a bit of the source (from a text file).
I have seen a lot of the MySQL Sever configuration File options none the parameters make sense to me, with respect to this issue.

The MySQL version is 8.0.19. Thank you for answering, and hope you, or anybody could give some light to this pain.

Options: ReplyQuote


Subject
Views
Written By
Posted
312
April 17, 2020 11:02AM
Re: Config or Installation Issue
341
April 17, 2020 02:35PM
327
April 17, 2020 03:07PM
324
April 18, 2020 10:29PM
340
April 20, 2020 01:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.