Finding number of Characters in SQL '' String
-
Hi, I have multiple SQL files that contains descriptions for various items, now this SQL will be imported into a database, however, because the descriptions comes from a 3rd party their description character length is sometimes longer than 255 , that of the field size in the database table. Is there a way I can go search through these files finding the descriptions that is longer than what is allowed?
-
Hello Johan-Havenga,
If there is a pattern in how they do the description, it should be possible.
Can show us an example and describe how you want it to be done?Cheers
Claudia
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login