(数据库基础与实例教程第章.ppt

独享表空间的设置 2.4.6 InnoDB表空间 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. use choose; alter table my_table engine=InnoDB; create table second_table( today datetime, name char(20) ); 2.4.6 InnoDB表空间 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 2.4.6 InnoDB表空间 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 使用MySQL命令 show variables like character%; 即可查看当前MySQL服务实例使用的字符集。 2.2.2 MySQL字符集及字符序 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. character_set_client：MySQL客户机字符集。 character_set_connection：数据通信链路字符集，当MySQL客户机向服务器发送请求时，请求数据以该字符集进行编码。 character_set_database：数据库字符集。 character_set_filesystem：MySQL服务器文件系统字符集，该值是固定的binary。 2.2.2 MySQL字符集及字符序 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. character_set_results：结果集的字符集，MySQL服务器向MySQL客户机返回执行结果时，执行结果以该字符集进行编码。 character_set_server：MySQL服务实例字符集。 character_set_system：元数据(字段名、表名、数据库名等) 的字符集，默认值为utf8。 2.2.2 MySQL字符集及字符序 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 使用MySQL命令“show collation;”即可查看当前MySQL服务实例支持的字符序。 2.2.2 MySQL字符集及字符序 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 2.2.3 MySQL字符集的转换过程 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 方法1：修改my.ini配置文件，可修改MySQL默认的字符集。 方法2：MySQL提供下列MySQL命令可以“临时地”修改MySQL“当前会话的”字符集以及字符序。 2.2.4 MySQL字符集的设置 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. set character_set_client = gbk; set character_set_connection = gbk; set character_set_dat