Classic Jhumka Earrings Silver INR 113.00 Free Shipping Buy Now
Black Jhumka Earrings & Studs INR 94.00 Free Shipping Buy Now
Classic Jhumka Earrings Silver INR 207.00 Free Shipping Buy Now
Beautiful stud earing INR 93.00 Free Shipping Buy Now
Different Size Hoop and Stud Earrings Set INR 243.00 Free Shipping Buy Now
Golden Hoop Earing INR 70.00 Free Shipping Buy Now
Home Questions & Answers Technology MySQL Question Answers What is the difference between CHAR and VARCHAR

    What is the difference between CHAR and VARCHAR

  • A list of differences between CHAR and VARCHAR:

    • CHAR and VARCHAR types are different in storage and retrieval.
    • CHAR column length is fixed to the length that is declared while creating table. The length value ranges from 1 and 255.
    • When CHAR values are stored then they are right padded using spaces to specific length. Trailing spaces are removed when CHAR values are retrieved.