Unknown datatype name 'WVARCHAR'

1

Hi, currently we have the following error Unknown datatype name ‘WVARCHAR’
I tried to change calcite charset using:
DREMIO_JAVA_SERVER_EXTRA_OPTS=’-Dsaffron.default.charset=UTF-16LE -Dsaffron.default.nationalcharset=UTF-16LE -Dsaffron.default.collation.name=UTF-16LE$en_US’

but PowerBI genrate a query with this expresion:
where cast(“NOMBRE_PROD_GEN” as WVARCHAR) = 'CRÉDITO SOBRE RUEDAS ’

I think that the problem is the accents

Any workaround about this?

2

This seems to be a problem with PBI generator an illegal type WVARCHAR rather than NVARCHAR.

Could you elaborate on what source you are using here?

3

In Dremio we have a Postgres datasource with raw reflection.
The field is type VARCHAR in datasource.
In windows I’ve installed the dremio driver and powerbi extension.

We analising and detect that power bi generate this wrong is because ODBC feature.
How can set disable this feature of driver? to no use WVARCHAR ??
I’ve been tried to create new PowerBi Connector to no use WVARCHAR, but I’m not ODBC expert, I don’t know how change it

4

I have finally managed to solve it.
the dremio connector, is really based on the one developed by Simba which worked through the drill ODBC driver using UTF-16 encoding.
The solution is to create a connector using the PowerQuery SDK and overwrite:

SQLColumns = (catalogName, schemaName, tableName, columnName, source) =>
            let
            OdbcSqlType.VARCHAR = 12,
            OdbcSqlType.WVARCHAR =-9,
            T_origen="CHARACTER VARYING",
            T_destino="WVARCHAR",

            FixDataType = (dataType) =>
                if dataType = OdbcSqlType.VARCHAR then
                    OdbcSqlType.WVARCHAR 
                else
                    dataType,

            FixDataTypeName = (dataType) =>
                if dataType = T_origen then
                    T_destino 
                else
                    dataType,

            Transform = Table.TransformColumns(source, { { "DATA_TYPE", FixDataType },{ "SQL_DATA_TYPE", FixDataType },{ "TYPE_NAME", FixDataTypeName } })                                                
            in
             Transform