Limit of characters of String type

Get Help
1

Hello,
I am trying to insert into the database a String that has 10.500 character long.
The problem is that in the database this values is cut at the position of the character 8.000, (only the first 8.000 characters of the string are inserted into the table and not the last 2.500.
Does metabase has a length limit for the String type?
Are there any possible solution to avoid this?

Thanks

2

Hi @Dovdtel87
Post "Diagnostic Info" from Admin > Troubleshooting, and which database type you're querying.

3

Thanks for your reply.
Here you have the info:
{
"browser-info": {
"language": "en-GB",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.102 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8",
"os.name": "Linux",
"os.version": "4.15.0-158-generic",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"sqlserver",
"snowflake"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.12"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-12-10",
"tag": "v0.40.7",
"branch": "release-x.40.x",
"hash": "07fdc71"
},
"settings": {
"report-timezone": null
}
}
}

4

@Dovdtel87 So is this related to SQL Server or Snowflake? And where are you seeing text being cut?
Latest release is 0.42.2: https://github.com/metabase/metabase/releases

5

So I do a query to see if the value I have inserted is correct:

49
493526×1558 218 KB

The string is the value under the red line.
Then I inspect it and I have the whole value that is inserted:

I copy and paste it to an online tool that counts the numbers of characters and it gives me that this string has 8.000 characters instead of the 10.500 it should have

6

@Dovdtel87 I cannot reproduce in the latest release against Postgres or MariaDB.