When you try to load into an existing Google BigQuery table or try to create a new table, an error might occur when the following is true:

• You use the BULKLOAD=YES LIBNAME or data set option.
• You use the SCANSTRINGCOLUMNS=YES LIBNAME or data set option.
• You have a character variable that contains at least one of the hex characters between '80'x and 'FF'x.
• The character variable is not the last variable in the table.
• The length of the value that contains the character is equal to the longest length that exists for any row for all character variables. If there is more than one occurrence of any of the characters in a single character value, the lengths do not have to be equal. The length of the value can be one less than the maximum length for each additional occurrence of the characters.

The error looks similar to the following:

ERROR: During insert: String data, right-truncated char

The workaround is to remove the SCANSTRINGCOLUMNS=YES option for inserts and use only the option for reads.