International Language UTF-8

About International Language UTF-8

The Database and ETL generally use ANSII encoding for the languages, but if the project uses International Languages (Specifically Asian like Japanese or Korean language) then formatting for UTF-8 encoding is necessary.

Setting the language for SQL Server

Within SQL Server database, this setup is performed depending upon the version of SQL Server used. SQL Server have schema using nchar/nvarchar types, which support all the characters as UTF-8 but with physical storage as UCS-2. No special database configuration needed in that case.

Note

Native UTF-8 support has been added to the SQL Server 2019 version.

Setting the language for SAP Data Services

Within the Data Services ETL, International Language fails to import if the UTF-8 encoding is not set up within the Datastore as shown below.