Archives of the TeradataForum
Message Posted: Mon, 08 Jul 2013 @ 16:19:50 GMT
I am trying to load Cyrillic alphabet into a table by using a FASTLOAD.
The first thing done in the FASTLOAD is:
set session charset "UTF8";
The Cyrillic alphabet seems to be activated in our database as we can check in the answer of this select:
SELECT CharSetName, CharSetId, InstallFlag FROM DBC.CharTranslationsV WHERE CharSetName='CYRILLIC1251_2A0' InstallFlag=Y
The target table of the loading is set with the CHARACTER SET UNICODE for those fields that are going to store the Cyrillic alphabet.
CREATE MULTISET TABLE STG_FICH282_20130509, NO FALLBACK ,NO BEFORE JOURNAL,NO AFTER JOURNAL ( --- NOMBRE_CLI VARCHAR(30)CHARACTER SET UNICODE, APELLIDOS_CLI VARCHAR(45)CHARACTER SET UNICODE, CODIGO_PAIS_CLI VARCHAR(3)CHARACTER SET UNICODE, DIRECCION_CLI VARCHAR(60) CHARACTER SET UNICODE , POBLACION_CLI VARCHAR(30)CHARACTER SET UNICODE, PROVINCIA_CLI VARCHAR(30)CHARACTER SET UNICODE,
The result of the execution seems ok according to the log, but I cannot see the Cyrillic alphabet using the SQL Assistant, and I tried with different fonts.
I tried also to export the results into a .txt.
It didnt work either.
Any idea what Am I missing?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|