Skip to main content

GENERAL

MySQL - How to Change VARCHAR Field Length

Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions. The effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used.

So, we could easily change field's length to be longer than 255 characters if (and only if!) MySQL we work with is version 5.0.3+:

1) Login to phpMyAdmin and go to a database

VLC Player Tips and Tricks

Inforbiro is an Information Technology and Marketing Agency with its own Internet marketing network BlicKlik. We have a lot of experience in software development as well as in Internet marketing and advertising. We constantly try not only to develop great web sites, mobile, desktop or facebook applications but also to share our knowledge.

Therefore, below is a collection of VCL Multimedia Player Tips and Tricks articles written on our company blog that could be useful to all of you.

Android - Web Vs. Native Applications

The latest features in Android programming allow us to create either native Android application or web Android apps.

OpenX Large Tables

You can find several tables in OpenX database that could be very large in comparation to other tables.

The database could keep growing constantly.

VLC Player - Disable Popup Notification

VLC media player is advanced multimedia software capable for reproduction of almost all media files.

Sometimes notification popups could be very anoyed takeing away your attention so here are steps how to turn it off.

1) Go to Tools > Preferences

2) Under section "Show settings", on the left lower corner, select "All" radio button

3) Go to Interface > Main interfaces > Qt

4) Uncheck "Show notification popup on track change"

5) Click "Save"