-
Capstone project 1.7
Hello,
While using the table importer to convert the
trade_idcolumn datatype from byte to ‘Char’, it only converts up to 9 values. After the 9th value, it shows as ” “. Additionally, if I convert thetrade_idcolumn to String/General type, a comma is added up to the first 9 values, like ,”1″, ,”2″.Please help me resolve this issue. Please find the attached screenshot.
Thanks,
Akash G
-
1 Reply
-
The “char” type can only hold a single character. So if you try to convert an input string that contains more than one character, such as “10”, it becomes the null value for char which is the space character. This is similar in principle to trying to convert a non-numeric string into a number.
-
This reply was modified 2 days, 6 hours ago by pgyorok.
-
This reply was modified 2 days, 6 hours ago by
Log in to reply.