Re: Config or Installation Issue
Posted by: Luis Benitez-Martell
Date: April 18, 2020 09:48PM

Thank you for replying, Peter. I followed your suggestion and I got this last grid of information:

show create table prodfarm;

(showed a Grid about prodfarm's structure)

show variables like 'char%';


# Variable_name Value
character_set_client utf8mb4
character_set_connection utf8mb4
character_set_database utf8mb4
character_set_filesystem binary
character_set_results utf8mb4
character_set_server utf8mb4
character_set_system utf8
character_sets_dir C:\Program Files\MySQL\MySQL Server 8.0\share\charsets\

I had used FOWARD ENGINNEIRING option to create all tables from the model,
saved SQL script file, copied to the SQL tab I previously created, and executed the script on it.

What did I do wrong? if the character set is the issue, Which should i use?

I think the server used 'utf8mb4' as default, because is not specified in the script.

Where do I go from here? To me is transparent. Thank again

Options: ReplyQuote


Subject
Views
Written By
Posted
118
April 17, 2020 11:02AM
118
April 17, 2020 03:07PM
Re: Config or Installation Issue
136
April 18, 2020 09:48PM
115
April 18, 2020 10:29PM
128
April 20, 2020 01:17AM


Sorry, only registered users may post in this forum.

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.