Limagito Filemover Software Blog and News

December 4, 2020

Export Chinese Text Data from SQL server database to CSV file

Q: I want to export Chinese Text data from an SQL server database to a CSV file. Setting up the Limagito rule was simple: SQL input and an output directory. I am actually using an SQL Select because the data that I want to export results from a join. Unfortunately the exported file is in ANSI encoding. Since my SQL Server source has nvarchar fields, some of them with Chinese text in them, I cannot use the CSV. Is there any way to tell Limagito to output CSV from an SQL Server source as UTF-8?

A: We had to add some new options in version v2020.12.4 to achieve this.

We added a basic example to get you started:

Added SQL as Source

Limagito File Mover SQL as Source

We’ll be using a simple QRY to get all the date from a database table:

Limagito File Mover SQL as Source Select Statement

We are using a MS SQL Database, connection Setup:

Limagito File Mover SQL as Source database setup

Some info about the Database table (Demo_10

) we’ll be using:

Add the query, simple seclect all statement:

Limagito File Mover SQL as Source Query

Important, Add the encoding you need. In this example we added UTF-8.

Limagito File Mover SQL as Source Common options

Destination Setup, WIN as Destination:

Limagito File Mover WIN as Destination

Destination File Result:

Limagito File Mover SQL to Csv File

RunTime Log Result:

Limagito File Mover SQL to Csv RunTime Log

If you need any help with this ‘Export Chinese Text Data’ question, please let us know.

Best Regards,

Limagito Team

By Limagito SQL , , Share: