Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Loading Cyrillic Alphabet
 
From:   MARIA JOSEFA RODRIGUEZ POSADA

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016