Hi Hans,
Thanks very much, I’ve created JIRA
https://issues.apache.org/jira/browse/TRAFODION-2669 , I think it will be
better if we change it a little bit, including the issue I mentioned in another
email. It says source type is 21 bytes and target type is 24 bytes, but in
reality the value
Yuan, you made a very good point, the error message is misleading. It shows the
target data type as CHAR(24 BYTES) when in reality it is CHAR(6). I think this
could be made better (probably not perfect) by a change in method
ExRaiseDetailSqlError() in file ExpError.cpp.
Do you want to file a
Thanks Jack,
This seems like a defect.
Please help to file a JIRA, so we can track this issue when you have free time.
Otherwise, we will create a JIRA to track this issue.
thanks,
Ming
From: Huang, Jack [mailto:jack.hu...@dell.com]
Sent: Wednesday, June 28, 2017 9:34 AM
To:
Hi Trafodioner,
There is a dump may related with trafodion odbc driver. I test the trafodion
workload with HammerDB and after 5 hours the dump created.
Please see the detail log in the attached file.
[root@trafodion HammerDB-2.22]# file core.60054
core.60054: ELF 64-bit LSB core file x86-64,
Hi,
The problem is how sqlci interprets its input data. In your case, sqlci
interprets the data as ISO8859-1, that makes the input 3*3 bytes or 9 ISO
8859-1 characters. It then translates those 9 (junk) characters into UTF-8,
requiring 18 bytes, and those don't fit into the target table. Once
I got the same error on sqlci. I would suggest you use trafci. Ture, it an
issue.
[cid:image003.jpg@01D2EF5C.DFD8E910]
Best Regards,
Kevin Xu
From: Xu, Kai-Hua (Kevin)
Sent: Tuesday, June 27, 2017 3:41 PM
To: user@trafodion.incubator.apache.org
Subject: RE: How many Chinese characters can be
Hi Yuan,
Curious, it works for me.
[cid:image002.jpg@01D2EF5B.BE524210]
Best Regards,
Kevin Xu
From: Liu, Yuan (Yuan) [mailto:yuan@esgyn.cn]
Sent: Tuesday, June 27, 2017 2:54 PM
To: user@trafodion.incubator.apache.org
Subject: How many Chinese characters can be stored in varchar(n chars)
Hi Trafodioneers,
I created one table as below,
>>create table test_utf8(a varchar(6) character set utf8);
--- SQL operation complete.
>>showddl test_utf8;
CREATE TABLE TRAFODION.SEABASE.TEST_UTF8
(
AVARCHAR(6 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT