Everyone, sometime, has their early morning post, well this is mine. What I decided to talk about is MySQL and Java as a background service (While listening to “The Deep Dark Woods – Charlie’s (Is Coming Down)”). Hell of a combination. MySQL (version any, mine is 5.0xx for production, 5.1 local) Whenever you build a … Continue Reading
CHAR and VARCHAR data types are pretty similar but with some differences between them. CHAR is saved in fixed length (the same length you used when declaring the column), whilst VARCHAR is saved in variable length. Lets take an example, using this table CREATE TABLE lengths( column_char CHAR(5), column_varchar VARCHAR(5) ); If I insert two … Continue Reading
I am starting with String data types of MySQL. Categorized under string data types in MySQL, we have these types CHAR and VARCHAR types BINARY and VARBINARY types BLOB and TEXT types ENUM type SET type Following the next posts, I will explain each of them and their usage. See you in the next post.
MySQL v5.x has a long list of data types it can manage. Starting from numbers, characters, strings, blobs etc. There are 3 main categories of data types that MySQL supports and manages String types Numeric types Date and Time types Starting today I will try to explain each of the data types in detail. MySQL … Continue Reading
As every application there is a starting point, some prefer drawing, some designing etc., as the first step of application development. I prefer separating the modules, and based on the module to build the database. I will be using MySQL v5.1. UTF-8 will be the encoding for multilanguage support, and InnoDB storage engine (since it … Continue Reading