Special thanks to:
- Download Instant Client from http://www.oracle.com/technetwork/indexes/downloads/index.html#database (you must be registered in Oracle; it's free). You will need
instantclient-basic-*-*.zip
andinstantclient-sdk-*-*.zip
files.
Special thanks to:
instantclient-basic-*-*.zip
and instantclient-sdk-*-*.zip
files.<?php | |
/** | |
* UUID class | |
* | |
* The following class generates VALID RFC 4122 COMPLIANT | |
* Universally Unique IDentifiers (UUID) version 3, 4 and 5. | |
* | |
* UUIDs generated validates using OSSP UUID Tool, and output | |
* for named-based UUIDs are exactly the same. This is a pure | |
* PHP implementation. |
/** http://stackoverflow.com/questions/12652234/sql-query-to-remove-special-characters **/ | |
DROP FUNCTION IF EXISTS `stripSpecialChars`; | |
DELIMITER ;; | |
CREATE FUNCTION `stripSpeciaChars`(`dirty_string` varchar(2048),allow_space TINYINT,allow_number TINYINT,allow_alphabets TINYINT,no_trim TINYINT) RETURNS varchar(2048) CHARSET utf8 DETERMINISTIC | |
BEGIN | |
/** | |
* MySQL function to remove Special characters, Non-ASCII,hidden characters leads to spaces, accents etc | |
* Downloaded from http://DevZone.co.in | |
* @param VARCHAR dirty_string : dirty string as input |