Help Center> Data Warehouse Service> Troubleshooting> Database Use> Byte Type Is Returned After a Table Column of the Character Type Is Read in Java
View PDF

Byte Type Is Returned After a Table Column of the Character Type Is Read in Java

Symptom

A column in a newly created database table is of the character type. However, after the column is read in Java, the returned type is byte.

For example, create a table using the following statement:

1
2
3
4
 
CREATE TABLE IF NOT EXISTS table01(
   msg_id character(36),
   msg character varying(50)
);

In Java, the code for reading the field of the character type is as follows:

1
 
ColumnMetaInfo(msg_id,1,Byte,true,false,1,true);

Possible Causes

CHARACTER(n) is a fixed-length character string. When the actual string length is insufficient, the database pads it with spaces. Then, Java uses the byte type to receive the string. CHARACTER VARYING(n) is a variable-length character string. Java uses the string type to receive it.

Parent topic: Database Use