MySQL field varchar also in the analytical Storage as string not as CLOB

Answered

Follow

0

Florijn Terstal

• January 28, 2019 15:22

Hallo,

It's seems some times datav has problem to see varchar(100) as a string... it makes CLOB type out of it..
I want every varchar and char to be string and not CLOB

• 1

  Comment actions Permalink

  

  Matthias Korn

  • January 29, 2019 10:45

  Hi Florijn,

  in order for strings to be created, the parameter createStringsAsClobs should be set to false.

  Best,
  Matthias

• 0

  Comment actions Permalink

  

  Florijn Terstal

  • January 29, 2019 10:07

  Hallo ,
  
  I need to change something about this.... the problem is... TEXT field in MySQL.. that becomes CLOB.. that's a field that cannot work with Tableau

• 0

  Comment actions Permalink

  

  Matthias Korn

  • January 29, 2019 10:39

  Hi Florijn,

  I have good news for you, I wasn't aware of it, but you can easily change the behaviour on the data source connection. By default, our MySQL connection will create strings as clobs, but when you add the following translator parameter by right clicking/edit on the datasource:

  createStringsAsClobs=true

  Since you are using native queries, the final translator parameters should look like this:

  supportsNativeQueries=true,createStringsAsClobs=true

  Best,
  Matthias

• 0

  Comment actions Permalink

  

  Florijn Terstal

  • January 29, 2019 12:12

  oke great that works... maybe should standard when adding MySQL connection string..

Please sign in to leave a comment.