Felipe Francisco felipecwb

The motherf*cking way the get Oracle database connections in PHP5 over Ubuntu

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 and instantclient-sdk-*-*.zip files.

	/ 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

	<?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.