Skip to main content

Posts

Showing posts with the label Database

What is collation in MySQL Database?

Collation in MySQL Database is a set of rules used in comparisons. Because many people use MySQL with data to be stored in languages other than English, they need to select the rules of comparisons which in turn depends on the character set used for storing that data. In MySQL, data is stored using a specific character set , which can be defind at different levels; i.e., the sever, the database, the table, and the column levels. Each character set has a default collation; for instance, the Latine1 character set uses the latin1_swedish_ci collation which is the Swedish c ase i nsensitive order. Usually, when someone develops an application that involves localization (using the local language; e.g., Arabic) or Internationalization (i.e., using multiple languages), they resort to Unicode (utf-8) which has several collations. In general, it is a good idea to set the character set to utf-8 and select the relevant collation or just accept the default utf8-general-ci....

Change port in Wamp server

Difference Between $ and $$ When you face the problem that Wampserver is not working or localhost is not working. There mainly because of three reason Namely : i) When in your system Skype (some application which use same port) is running ii) In your system IIS is running iii) For any other reason confliction We will sort out it one by one.   1) When in your system skype (some application which use same port) is running , Aassume in your  system  skype is running at that time first start your wamp after that start your skype   then both will work.       It is because skype use either port 80 or 443 .       If you dont want to do each and every time just follow the steps for permanent solution     i) Open skype ->> select tools ->> option     ii) Now click on advanced and in advance connection . You can find a checkbox Use po...

MySQL Queries

Connecting to MySQL Database

Basic Knowledge of PhpMyadmin