<div dir="ltr"><br><br><div class="gmail_quote">On Mon, Oct 6, 2008 at 9:27 PM, Krishnan Mani <span dir="ltr"><<a href="mailto:krishnanm75@yahoo.com">krishnanm75@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;" valign="top">
<br><br>1.4.3 The MySQL server is it configured to use
UNICODE?<br><br>NB: mysqld service must be started.<br>In a Terminal window, type the command mysql, then an SQL<br>to display variables content server configuration.<br>Text of query:<br><br>show where variable_name variables like 'char%';<br>
UNQUOTE<br></td></tr></tbody></table></blockquote><div><br><br><br>In mysql that i have, I get this:<br><br><span class="HcCDpe"></span>mysql> SHOW VARIABLES LIKE 'character\_set\_%';<br>+--------------------------+--------+<br>
| Variable_name | Value |<br>+--------------------------+--------+<br>| character_set_client | latin1 |<br>| character_set_connection | latin1 |<br>| character_set_database | latin1 |<br>| character_set_filesystem | binary |<br>
| character_set_results | latin1 |<br>| character_set_server | latin1 |<br>| character_set_system | utf8 |<br>+--------------------------+--------+<br>7 rows in set (0.00 sec)<br><br><br>So even though my system is utf8, mysql databases are being created in latin1. Is my understanding correct?<br>
<br>Thanks.<br><br><br><br><br><br><br></div></div><br></div>