英文系统2008安装ms sql2005,collation选择列表中没有英文

wangzh2008 2010-08-31 01:57:34

无法把服务的collation设置成Sql_Latin1_General_CP1_CI_AS.

如选择了Latin1_General,安装后collation是Latin1_General_CI_AS.

请帮忙如何解决，谢谢！

...全文

82 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

wangzh2008 2010-08-31

打赏
举报

[Quote=引用 2 楼 billpu 的回复:]
安装下windows多语种包
[/Quote]

已经安装过了

billpu 2010-08-31

打赏
举报

安装下windows多语种包

claro 2010-08-31

打赏
举报

是OS的问题还是DBMS的问题？

纯帮顶

在一个团队项目中，没有约定好Collation, 在 MS SQL Server中编程就会遇到这样的问题：Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. 因为编码问题，不同编码的字符串并不能直接进行比较，这种有两个解决方法，1是在 query中指定用某一个collation进行比较, 另外一个就是修改column的 collation type 来避免这种错误。第二种方法，一个

- Eclipse 2019-03 is now the default platform - Embedded editor activation problem fixed (Linux) - SQL editor: - SQL errors now shown in results panel instead of modal dialog (configurable) - Certain long strings visibility problem was fixed - Auto completion was fixed for CALL/EXEC keywords - Tables/schemas were removed from columns proposals - Context menu was improved (redundant items were removed) - Numerous NPE errors were fixed - Multi-statements scripts formatter was improved (adding statement delimiters) - Database-specific named parameters prefix was added - SQL formatting was fixed - Morph delimited list formatter was fixed (spaces in tokens) - Data editor: - Unnecessary focus changing was fixed - Calc panel: strings/numbers aggregation toggle was added - Data transfer: fetch size was added in export settings (may significantly improve performance) - ERD (custom diagrams): - Additional styles were added for notes (colors, transparency, border, font settings) - Notes now can be connected with entities - Dashboards: - Timeseries dashboards rendering was fixed. - New dashboards extraction model was added (statistics reading by intervals) - Exasol dashboards were added - PostgreSQL: - Alpha version of GIS/spatial data viewer (maps) was added - Explain for queries with parameters was fixed - Database description reading was fixed (PG < 9.4) - Greenplum: tables reading for GP 4.x was fixed - Oracle: - Public synonyms in auto-completion - Session manager now shows instance ID (for clusters) - MySQL/MariaDB: - New database dialog now uses server charset/collation defaults - Native client was updated (problems with dump/restore compatibility) - MS SQL Server/Azure: driver version was updated, support of AD MSI authentication was added - Elasticsearch: metadata reading was fixed (schema/table names escaping) - Pervasive SQL driver configuration was added - MySQL NDB cluster driver configuration was added - Google BigQuery driver was updated - Numerous localization bugs were fixed - Many minor UI bug fixes

目录目录正确认识SQL Server的字符集选择合适的SQL Server字符集错误使用SQL Server的字符集参考资料正确认识SQL Server的字符集SQL Server作为一个国际化产品，支持多语言环境。在SQL Server中，字符集被称为排序规则（即Collation）。排序规则不仅影响记录行的sort顺序，还影响中文显示是否乱码等。在SQL Server中，排序规则可在3

在SQL 2005的前一个版本SQL 200中如果需要更改一个Server的COLLATION，我们可以执行SQL 2000自带的一个小工具rebuildm，用于重建master数据库。在SQL 2005中微软不再提供这个工具，...

什么是排序规则（collation）关于SQL Server的排序规则，估计大家都不陌生，在创建数据库时我们经常要选择一种排序规则（conllation），一般我们会留意到每一种语言的排序规则都有许多种，比如标准大陆简体中文Chinese_PRC的排序规则就有数十种之多这些排序规则有什么作用呢？让我们先来看看MS官方的解释：排序规则指定了表示每个字符的位模式。它还指定了用...

疑难问题

22,209

社区成员

121,730

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章