Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Finding number of Characters in SQL '' String

    Help wanted · · · – – – · · ·
    2
    2
    1761
    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 Havenga
      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 Frank 1 Reply Last reply Reply Quote 0
      • Claudia Frank
        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
        Copyright © 2014 NodeBB Forums | Contributors