Help explain character_set_database and collation_database
Posted by: Gary Yang
Date: August 13, 2019 03:34PM

Hello! Would you please help me understand these two variables? The reference manual reads:

"The character set and collation for the default database can be determined from the values of the character_set_database and collation_database system variables. The server sets these variables whenever the default database changes."

Suppose I issued SQL statement "use db1;". Now db1 is my default database. If db1 was created with character set A and collation B, which are different from the values of character_set_database (X) and collation_database (Y), how could these two variables affect my "default database" db1? Thank you in advance.

Options: ReplyQuote

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.