Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 30 Jan 2004 @ 10:09:57 GMT

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

Subj:   Re: mload with utf8 charset..
From:   Vivek Pandey

Hi again,

I got a solution to this problem & hence am posting it here for the benefit of others.

Since the characters are of variable bytes in a specific field Mload does not know when to take single byte or double byte or triple byte. So the solution could be to push all the chars in one temp table & then chop them from there using the SUBSTR function.

One solution for inserting all the chars is the input data file should be delimited with a character so that you can use VARCHAR instead of char in your layout.

Then you can have your layout with VARCHAR like

.field col1 * varchar(100) ---> 100 is here as an example. Value should be greater than your largest field above.

.IMPORT statement should be like this:

.Import infile unicode
        format vartext '|'
        Layout unicode2
apply INSERT

NOTE : This doesn't needs your Teradata to be Kanji-enabled !!

Thanks, Vivek.

  <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: 15 Jun 2023