mysql修改表、字段、库的字符集代码,MYSQL代码库,德仔网

代码语言
代码分类
【MYSQL】 mysql修改表、字段、库的字符集
作者:Dezai.CN / 发布于2011/9/15/ 2844
<div>
修改数据库字符集：
<div class="wp_syntax">
<div class="code">
<pre style="font-family: monospace" class="sql"><span style="color: rgb(153,51,51); font-weight: bold">ALTER</span> <span style="color: rgb(153,51,51); font-weight: bold">DATABASE</span> db_name <span style="color: rgb(153,51,51); font-weight: bold">DEFAULT</span> <span style="color: rgb(153,51,51); font-weight: bold">CHARACTER</span> <span style="color: rgb(153,51,51); font-weight: bold">SET</span> character_name <span style="color: rgb(102,204,102)">[</span><span style="color: rgb(153,51,51); font-weight: bold">COLLATE</span> <span style="color: rgb(102,204,102)">...</span><span style="color: rgb(102,204,102)">]</span>;</pre>
</div>
</div>
把表默认的字符集和所有字符列（CHAR,VARCHAR,TEXT）改为新的字符集：
<div class="wp_syntax">
<div class="code">
<pre style="font-family: monospace" class="sql"><span style="color: rgb(153,51,51); font-weight: bold">ALTER</span> <span style="color: rgb(153,51,51); font-weight: bold">TABLE</span> tbl_name <span style="color: rgb(153,51,51); font-weight: bold">CONVERT</span> <span style="color: rgb(153,51,51); font-weight: bold">TO</span> <span style="color: rgb(153,51,51); font-weight: bold">CHARACTER</span> <span style="color: rgb(153,51,51); font-weight: bold">SET</span> character_name <span style="color: rgb(102,204,102)">[</span><span style="color: rgb(153,51,51); font-weight: bold">COLLATE</span> <span style="color: rgb(102,204,102)">...</span><span style="color: rgb(102,204,102)">]</span>
如：<span style="color: rgb(153,51,51); font-weight: bold">ALTER</span> <span style="color: rgb(153,51,51); font-weight: bold">TABLE</span> logtest <span style="color: rgb(153,51,51); font-weight: bold">CONVERT</span> <span style="color: rgb(153,51,51); font-weight: bold">TO</span> <span style="color: rgb(153,51,51); font-weight: bold">CHARACTER</span> <span style="color: rgb(153,51,51); font-weight: bold">SET</span> utf8 <span style="color: rgb(153,51,51); font-weight: bold">COLLATE</span> utf8_general_ci;</pre>
</div>
</div>
只是修改表的默认字符集：
<div class="wp_syntax">
<div class="code">
<pre style="font-family: monospace" class="sql"><span style="color: rgb(153,51,51); font-weight: bold">ALTER</span> <span style="color: rgb(153,51,51); font-weight: bold">TABLE</span> tbl_name <span style="color: rgb(153,51,51); font-weight: bold">DEFAULT</span> <span style="color: rgb(153,51,51); font-weight: bold">CHARACTER</span> <span style="color: rgb(153,51,51); font-weight: bold">SET</span> character_name <span style="color: rgb(102,204,102)">[</span><span style="color: rgb(153,51,51); font-weight: bold">COLLATE</span><span style="color: rgb(102,204,102)">...</span><span style="color: rgb(102,204,102)">]</span>;
如：<span style="color: rgb(153,51,51); font-weight: bold">ALTER</span> <span style="color: rgb(153,51,51); font-weight: bold">TABLE</span> logtest <span style="color: rgb(153,51,51); font-weight: bold">DEFAULT</span> <span style="color: rgb(153,51,51); font-weight: bold">CHARACTER</span> <span style="color: rgb(153,51,51); font-weight: bold">SET</span> utf8 <span style="color: rgb(153,51,51); font-weight: bold">COLLATE</span> utf8_general_ci;</pre>
</div>
</div>
修改字段的字符集：
<div class="wp_syntax">
<div class="code">
<pre style="font-family: monospace" class="sql"><span style="color: rgb(153,51,51); font-weight: bold">ALTER</span> <span style="color: rgb(153,51,51); font-weight: bold">TABLE</span> tbl_name <span style="color: rgb(153,51,51); font-weight: bold">CHANGE</span> c_name c_name <span style="color: rgb(153,51,51); font-weight: bold">CHARACTER</span> <span style="color: rgb(153,51,51); font-weight: bold">SET</span> character_name <span style="color: rgb(102,204,102)">[</span><span style="color: rgb(153,51,51); font-weight: bold">COLLATE</span> <span style="color: rgb(102,204,102)">...</span><span style="color: rgb(102,204,102)">]</span>;
如：<span style="color: rgb(153,51,51); font-weight: bold">ALTER</span> <span style="color: rgb(153,51,51); font-weight: bold">TABLE</span> logtest <span style="color: rgb(153,51,51); font-weight: bold">CHANGE</span> title title <span style="color: rgb(153,51,51); font-weight: bold">VARCHAR</span><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(204,102,204)">100</span><span style="color: rgb(102,204,102)">)</span> <span style="color: rgb(153,51,51); font-weight: bold">CHARACTER</span> <span style="color: rgb(153,51,51); font-weight: bold">SET</span> utf8 <span style="color: rgb(153,51,51); font-weight: bold">COLLATE</span> utf8_general_ci;</pre>
</div>
</div>
查看数据库编码：
<div class="wp_syntax">
<div class="code">
<pre style="font-family: monospace" class="sql"><span style="color: rgb(153,51,51); font-weight: bold">SHOW</span> <span style="color: rgb(153,51,51); font-weight: bold">CREATE</span> <span style="color: rgb(153,51,51); font-weight: bold">DATABASE</span> db_name;</pre>
</div>
</div>
查看表编码：
<div class="wp_syntax">
<div class="code">
<pre style="font-family: monospace" class="sql"><span style="color: rgb(153,51,51); font-weight: bold">SHOW</span> <span style="color: rgb(153,51,51); font-weight: bold">CREATE</span> <span style="color: rgb(153,51,51); font-weight: bold">TABLE</span> tbl_name;</pre>
</div>
</div>
查看字段编码：
<div class="wp_syntax">
<div class="code">
<pre style="font-family: monospace" class="sql"><span style="color: rgb(153,51,51); font-weight: bold">SHOW</span> <span style="color: rgb(153,51,51); font-weight: bold">FULL</span> <span style="color: rgb(153,51,51); font-weight: bold">COLUMNS</span> <span style="color: rgb(153,51,51); font-weight: bold">FROM</span> tbl_name;</pre>
</div>
</div>
</div>
试试其它关键字
　字符集　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)