Microsoft SQL Server database Unicode support

Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Prior to version 9.40, Service Manager used the VARCHAR, CHAR, and TEXT data types to store text strings in a Microsoft SQL Server database. Microsoft SQL Server relies on database collation to support a specific language. Although some languages share the same collation, most languages do not. As a result, Service Manager did not support multiple languages when running on a SQL Server database.

Service Manager 9.40 is enhanced to support the Unicode data type on SQL Server. You can store text string in multiple languages by using the Unicode data type. When you run the server configuration utility, if you select the Use Unicode Data Type check box for SQL Server (see the following figure), Service Manager creates data with the Unicode data type when it loads the applications and demo data.

The following table provides the mapping between the old and new data types.

Non-Unicode	Unicode
VARCHAR	NVARCHAR
CHAR	NCHAR Note This occurs only when the CHAR field length is greater than 1.
TEXT	NVARCHAR(MAX)

Non-Unicode

Unicode

VARCHAR

NVARCHAR

CHAR

NCHAR

Note This occurs only when the CHAR field length is greater than 1.

TEXT

NVARCHAR(MAX)

The operation is not reversible, which means once you have enabled this option, you must use the Unicode data type when adding new data. When your SQL Server database uses the Unicode data type, the read-only flag Use Unicode Data Type in the sqlserver record of the sqldbinfo table is automatically turned on.

Note The following four system tables will not use Unicode: dbdict, licenseinfo, lock, and lockshared.

Support of the Unicode data type is available only for new installations of the Service Manager 9.40 or later applications. If you are upgrading from a previous version of the applications, this option is not available.

For information about how to enable the Unicode support, see Install the Service Manager Server.

Related topics

Connect

Micro Focus Marketplace

ITSM Blog for IT Service Management

ITSM Community

Documentation Forum

Learn

Software Support Online

Software Support Downloads

Software Education Services

Contact

Send Help Center feedback

Submit Service Request

View Service Requests