CHAR_LENGTH is character count whereas the LENGTH is byte count. The numbers are same for Latin characters but they are different for Unicode and other encodings.
All posts by Pramod T P
OOP
Object-oriented programming (OOP) is a programming language model organized around objects rather than “actions” and data rather than logic. Historically, a program has been viewed as a logical procedure that takes input data, processes it, and produces output data.
MySQL Port
The default port for MySQL server is 3306.
MySQL Features
The following list shows the most important properties of MySQL.
- Clients and Tools
- Localization
- Connectivity
- Scalability and Limits
- Security
- Data Types
- Client/Server Architecture
- Stored procedures
- Views
- SubSELECTs
- SQL compatibility
- Triggers
- Unicode
- User interface
- Full-text search
- Replication
- Transactions
- Foreign key constraints
- GIS functions
- Programming languages
- ODBC
- Platform independence
- Speed
- Relational Database System
ACID
In computer science, ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties that guarantee that database transactions are processed reliably. In the context of databases, a single logical operation on the data is called a transaction. For example, a transfer of funds from one bank account to another, even involving multiple changes such as debiting one account and crediting another, is a single transaction.
Difference Between jQuery and jQuery U
jQuery is the core library. jQueryUI is built on top of it. If you use jQueryUI, you must also include jQuery.
jQuery UI
jQuery UI is a curated set of user interface interactions, effects, widgets, and themes built on top of the jQuery JavaScript Library that can be used to build interactive web applications.
jQuery Difference Between .stop(true,true) And .finish()
The .finish() method is similar to .stop(true, true) in that it clears the queue and the current animation jumps to its end value. It differs, however, in that .finish() also causes the CSS property of all queued animations to jump to their end values, as well.
jQuery .finish() Method
The .finish() method stops all queued animations and places the element(s) in their final state. This method was introduced in jQuery 1.9.
jQuery Migrate Plugin
With release of 1.9 version of jQuery, many deprecated methods were discarded and they are no longer available. But there are many sites in production which are still using these deprecated features and it’s not possible to replace them overnight. So jQuery team provided with jQuery Migrate plugin that makes code written prior to 1.9 work with it.
So to use old/deprecated features, all you need to do is to provide reference of jQuery Migrate Plugin.