mysql change database charset to unicode

SELECT concat('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') as stmt

FROM `information_schema`.`TABLES` t

WHERE 1

AND t.`TABLE_SCHEMA` = 'database_name'

ORDER BY 1

OLAT email problem

once you could not send emails and came accross this:

DEBUG: setDebug: JavaMail version 1.3

DEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtp,gnu.mail.providers.smtp.SMTPTransport,nferrier@tapsellferrier.co.uk]

java.lang.NoSuchMethodException: gnu.mail.providers.smtp.SMTPTransport.(javax.mail.Session, javax.mail.URLName)

you should install java mail components, I installed:

geronimo-javamail-1.3.1-api-1.1-4jpp

sun-mail-1.4-3jpp

classpathx-mail-1.1.1-4jpp.2




And the problem was solved.