The precise instructions are here:
http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html
...but if it is your local home installation you could also recompile
mysql specifying utf8 when you run configure.
Thank you for the very helpful advice.
I understand what it is you're saying I can accomplish, but I'm fuzzy on
the specifics, because, if it weren't already apparent, I'm a bit of a
newbie at this stuff.
I get that I can use commands with the --with-charset=utf8 perameter to
rebuild (?) my server with utf8 as the default encoding.
But you see, I installed MySQL from within a program called Synaptic
within Ubuntu. On the upside, it was very easy to get my MySQL
installation up and running. On the downside, I didn't see or do any
configuration settings our source code building, which means I'm
clueless as to where this stuff happens.
Being the exploratory newbie that I am, I tried the following:
[EMAIL PROTECTED]:~$ mysqld --character-set-server=utf8
060215 11:40:58 [Warning] Can't create test file
/var/lib/mysql/ubuntu1.lower-test
060215 11:40:58 [ERROR] Can't start server: Bind on TCP/IP port: Address
already in use
060215 11:40:58 [ERROR] Do you already have another mysqld server
running on port: 3306 ?
060215 11:40:58 [ERROR] Aborting
060215 11:40:58 [Note] mysqld: Shutdown complete
[EMAIL PROTECTED]:~$ ./configure --with-charset=utf8
bash: ./configure: No such file or directory
I kind of knew it wasn't going to work when I tried it, but I thought
I'd dive in anyway.
Is it possible I can get a slighly more newbie-friendly set of
instructions on how I can either reconfigure my MySQL server, or at
least permanently alter the system variables?
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
