Skip to main content

MySQL Illegal mix of collations

MySQL Illegal mix of collations

A character encoding details how each symbol is represented in binary (and therefore stored in the computer). For example, the symbol é (U+00E9, latin small letter E with acute) is encoded as 0xc3a9 in UTF-8 (which MySQL calls utf8) and 0xe9 in Windows-1252 (which MySQL calls latin1). A character set is the alphabet of symbols […]

openSmpp configuration with Mysql

openSmpp configuration with Mysql

If you need to install openSMPP please have a look on “Install Kannel Addons” OpenSMpp is Kannel addon; used to allow smpp clients to connect to kannel gateway and send SMS over SMPP protocol. following are the steps for configuring openSMPP with mysql as storage of DLR. Create a Mysql Database if you don’t have […]

Install Kannel Addons; opensmpp and sqlb...

Install Kannel Addons; opensmpp and sqlbox

If you need to install kannel with mysql support please refer to this post “How to Install Kannel” Once you have installed the kannel with Mysql support, you can install additional addons of kannel which are opensmpp and sqlbox. Install openSMPP (you can remove the –with-kannel-dir, but some distributions do not automatically find the kannel […]

How to run large sql script

How to run large sql script

some times you have to run a large SQL script in SQL server and “Sql Server Management Studio” dies when you load the large file. To import / run the large script you need to use SQL Server command line tool sqlcmd there are many parameters for this command line toll use this for full list […]