带有全文搜索的“Æ"丹麦民族字符问题 [英] 'Æ' danish national character problem with full text search

问题描述

当前，我正在使用"Microsoft SQL Server 2008 R2(SP1)-10.50.2500.0(X64)2011年6月17日00:54:03版权所有(c)Windows NT上的Microsoft Corporation Enterprise Edition(64位) 6.1< X64> (内部版本7601:Service Pack 1) sql server的版本.

我添加了丹麦语注册表来支持丹麦语全文搜索，并且它正在显示它，并且我已经对其进行了配置.

但是我仍然面临着搜索丹麦民族字符"problem"的问题.

任何人都可以提出建议以改善此问题，或者我需要为以上提供的版本安装任何修补程序吗?:(

Currently i''m using "Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) " version for sql server.

I have added danish language registry to support danish language for full text search and it is showing it and i have configured it.

But i still facing problem for ''Æ'' danish national character to search.

Can anyone provide suggesion to improve this or do i need to install any hotfix for above provided version?:(

推荐答案

请参阅我对问题的评论如我所说，您的问题没有描述，但是您需要使用Unicode和Unicode SQL数据类型，例如NCHAR，NVARCHAR2，NCLOB.请参阅:
http://docs.oracle.com/cd/B10500_01/server.920/a96529/ch6.htm#1011105 [ ^ ]，
http://en.wikipedia.org/wiki/Unicode [ http://unicode.org/ [ ^ ]，
http://www.unicode.org/faq/utf_bom.html [

Please see my comment to the question. As I say, your problem is not described, but you need to use Unicode, and Unicode SQL data types such as NCHAR, NVARCHAR2, NCLOB. Please see:
http://docs.oracle.com/cd/B10500_01/server.920/a96529/ch6.htm#1011105[^],
http://en.wikipedia.org/wiki/Unicode[^],
http://unicode.org/[^],
http://www.unicode.org/faq/utf_bom.html[^].

—SA

这篇关于带有全文搜索的“Æ"丹麦民族字符问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！