Archives of the TeradataForum

Message Posted: Mon, 08 Jul 2013 @ 16:19:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi

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?

	<Prev	Next>		<<First	<Prev	Next>	Last>>