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

Written By
April 17, 2020 11:02AM
April 17, 2020 03:07PM
Re: Config or Installation Issue
April 18, 2020 09:48PM
April 18, 2020 10:29PM
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.