Jim McIver wrote: > I've been struggling with mysql and dbmail. (SLES 10) > > I finally believed I had mysql 5.0.18 converted to utf8 by putting > the following in /etc/mycnf > > default-character-set = utf8 > character-set-server = utf8 > init-connect='SET NAMES utf8'
Since you're a self professed n00b, don't do that. > > Do I need to set three of the character variables(client, connection, > and results) back to latin1? > thx, Yes. That's the easiest solution. Looks like the charset fixes work for latin1 storage just fine. UTF8 with unicode collation will probably cover most charsets, but if you don't care about supporting non-western charsets latin1 will cover your bases. Converting an existing latin1 mysql store will be documented, but isn't yet. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
