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 […]
MySQL Illegal mix of collations
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...
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
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 […]
Find procedure or function in SQL Server...
If you have lots of functions or procedure and you forgot the name, you can use the following query to find by name Thanks
Server 2008 remote desktop copy fails
While you are doing remote desktop to a Windows Server 2008, and you copy text or a file, it do not copy. seems like the clipboard is not working. Copying from remote desktop is managed by ‘rdpclip’ process. and for some reason it gets corrupted or do not work properly. to fix this issue just follow this open […]
CURL ERROR 7 Failed to connect to Permis...
“CURL ERROR 7 Failed to connect to Permission denied” error is caused, when for any reason curl request is blocked by some firewall or similar thing. you will face this issue when ever the curl request is not with standard ports. for example if you do curl to some URL which is on port 1234, […]
Shrink SQL Server 2008
Normally when a database in Microsoft Sql Server 2008 is created the recovery model is full and that causes huge disk space usage and with usage of database the log file increases in size. Some times you may need to clean the log file, so here you go.
Get SMSC Status
kannel do not directly gives you status for any SMSC it is connected with. i have been asked many times by many that how can we get the status of a given SMSC. Many times one need to make some decision on current status of SMSC that weather or not one should this SMSC to sent Message. […]
How to install Kannel
Download Get sources using the following command where <project> is: gateway, sqlbox or opensmppbox. Once you have the kannel source, navigate to source directory which typically is [YOUR_DOWNLOAD_PATH]/trunk/ Here you can compile kannel wtih mysql support or without mysql. Install Kannel Without Mysql Support Install Kannel With Mysql Support Once you have installed kannel you can locate […]