i create remote mysql and i need to change the charachter set and collation in order to support hebrew language, once i am updating it from remote DB tool , i am trying to modify the database environment variables but after reconnecting to the database i am getting the default values (latin1) and i need it as UTF8
You can set the collection and charsets of your tables directly to whatever you want. However, you cannot change system settings (like the default charset and collation) because those settings would affect all accounts on the database server and not just your own databases.