[jira] [Created] (TRAFODION-2366) odb copy or load with Chinese characters will return gibberish

[zhangliang (JIRA)]

zhangliang created TRAFODION-2366:
-------------------------------------

             Summary: odb copy or load with Chinese characters will return 
gibberish
                 Key: TRAFODION-2366
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2366
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: zhangliang
            Assignee: zhangliang
            Priority: Minor


odb cmd is 
./odb64luo -u zale -p zale -d gy_poc -l 
src=sample.csv:tgt=trafodion.odb_copy.load_ch:max=500000:rows=5000:parallel=2:loadcmd=UL:fs=,:bad=bad2

File to load with Chinese characters  is like
...
SW001600,测试,2000/1/29 13:05:00,2.62,
SW001600,测试,2000/1/29 13:25:00,2.62,
SW001600,测试,2000/1/29 14:10:00,2.61,
SW001600,测试,2000/1/29 09:55:00,2.63,
SW001600,测试,2000/1/29 13:35:00,2.62,
SW001600,测试,2000/1/29 11:00:00,2.64,
SW001600,测试,2000/1/29 13:45:00,2.62,
...

While select from sqlci or DB manager, return gibberish, like:

ST_STATIONID        ST_STATIONNAME                                             
DT_TIME            NM_OUTWATER NM_INWATER
-------------------- 
------------------------------------------------------------ 
------------------- -------------- ------------
HY007415             大戢山                                                  
 2000-01-01 10:00:00           0.00         NULL
HY007415             大戢山                                                  
 2000-01-02 10:00:00           0.00         NULL
PDHFA366             五号沟                                                  
 1970-01-01 00:50:00           1.56         NULL
SW001100            罗店                                                      
2000-01-01 12:00:00           1.56         NULL
SW001600            五号沟                                                   
2000-01-29 09:25:00           2.63         NULL
SW001600            五号沟                                                   
2000-01-29 09:30:00           2.63         NULL
SW001600            五号沟                                                   
2000-01-29 09:35:00           2.63         NULL
...

HY007415        大戢山       946692000000    0       
HY007415        大戢山       946778400000    0       
PDHFA366        五号沟       -25800000       1.56    
SW001100        罗店  946699200000    1.56    
SW001600        五号沟       949109100000    2.63    
SW001600        五号沟       949109400000    2.63


The same as copy function.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)