Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Why is the default mapping of Short to TINYINT for MSSQL-server?

Hello,
Looking at "org.talend.core.runtime/mappings/mapping_MSSQL.xml" I see:
<talendType type="id_Short">
<dbType type="TINYINT" default="true" />
<dbType type="SMALLINT IDENTITY" />
<dbType type="SMALLINT" />
<dbType type="TINYINT IDENTITY" />
<dbType type="BIGINT" />
<dbType type="BIGINT IDENTITY" />
<dbType type="INT" />
<dbType type="INT IDENTITY" />
</talendType>

However Short is a two byte integer and TINYINT is one byte integer. Is there a special reason for this that I am not seeing or is this a bug?
Labels (3)
1 Reply
Anonymous
Not applicable
Author

yep, it seems to be a bug
you might want to create add it to the bugtracker
these links clear the case.
java type
http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Short.html#MAX_VALUE
mssql type
http://msdn.microsoft.com/en-us/library/ms187745.aspx
thanks for the heads-up