Community
    • Login

    Finding number of Characters in SQL '' String

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    2 Posts 2 Posters 2.0k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Johan HavengaJ
      Johan Havenga
      last edited by

      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?

      Claudia FrankC 1 Reply Last reply Reply Quote 0
      • Claudia FrankC
        Claudia Frank @Johan Havenga
        last edited by

        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

        1 Reply Last reply Reply Quote 0
        • First post
          Last post
        The Community of users of the Notepad++ text editor.
        Powered by NodeBB | Contributors