load问题,急啊
<p><font face="Verdana">The database you are attempting to LOAD was DUMPed under a different sort order ID (42) or character set ID (2) than the ones running on this server (SortOrd = 50, CharSet = 2). If the sort orders differ, at least one of them is non-binary. </font></p><p><font face="Verdana">以前SortOrd = 42,这个在set sort中应该选择哪一个排序方式啊</p></font> <p><font face="Verdana">应该是字符集不一致的问题。</font></p>
<p><font face="Verdana">解决办法：</font></p>
<p><font face="Verdana">在安装目录下有一个locales目录，其中有个文件locales.dat文件，用记事本打开，找到选项，修改默认的（default）字符集，就可以了。<br/></font></p> 补充一下,数据库备份的字符集\排序与当前服务的字符集\排序不一致<br/>如果当前服务是新建来恢复以前的备份的,应先配置字符集和排序方式,保持与原来的一致<br/><br/>
页:
[1]