Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

set mysql collation and charachter set

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

Comments

  • 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.

This discussion has been closed.