Education
Abstract
How to most efficient unload data with Internal/Latin8 encoding to UTF8?
Content
Internal/Latin8 datatypes doesn't allow you to in-place conversion for SQL queries.
You will need to convert data after it been stored locally (with tools like iconv or nzconvert).
If you however need in-place convertion the fastest way is to use 'nzsql -o' command with setting LC_ALL to en_US.UTF-8 (or similar depending on your system) and then pipe output to a text file.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSUSQ8","label":"IBM Netezza Analytics"},"Component":"","Platform":[{"code":"PF004","label":"Appliance"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
03 June 2022
UID
ibm10734809