I have a number of company names that I am trying to display in a table that have an ampersand in the name. For example, B&M Trucking. However, when it shows in the database, it says B M Trucking, which affects the search funtion. Does anyone know what causes that?
Hello @tomm,
It could be an issue with the database field type:
If the column type is incorrectly configured (e.g., set to a numeric type instead of a string), special characters may be removed.
3 Likes
All of the fields are set to string. In fact I can see the ampersands in another column just fine, and both columns are set up the same way.
i have face this same issue with my database file type:
but then my friend suggest me and then he give me a solution and then he solve my whole problem in just 30 mins
1 Like
Hey @tomm! Thanks for reaching out.
Can you clarify whether you are unable to see the ampersand in the database itself or just in the Retool table? Databases don't typically have an issue storing special characters, but it's definitely possible that formatting is being lost in transit or within Retool itself.
It's not ideal - and I'm curious to get more context before resorting to this - but one solution is to store the string as B&M instead.
I know you may not be working on this particular project anymore, but let us know if you need any additional assistance with this @tomm!