ITAM Data Importer and Multi Language Characters within SQL Server database

book

Article ID: 48622

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

Using the ITAM Data Importer to import Multi Language Characters (Polish, Russian, etc) within SQL Server database, the special characters are replaced by'?' or '_'

Solution:

Prepare the source file:

  1. Copy the data that contains the Multi Language Characters into notepad with no column headings

  2. Save the file, choose to save with the encoding value of Unicode.

  3. Once the txt file is saved, rename it to a .csv.

  4. Run the ITAM Data Importer using the newly renamed csv file

The values will be stored correctly in the database.

However, to see the correct values from sql server management studio, you must run a sql statement using the 'LIKE' condition.

example:

select * from ca_location where location_name like <'%MultiLanguageValue%>

Environment

Release:
Component: BITCM