Search - Joel Lipman .Com

1. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... SET latin1 COLLATE utf8-general-ci; // set text fields to utf8 SET NAMES 'utf8'; This does nothing: // convert the foreign character using PHP to htmlentities $my_description = htmlentities($my_description); $my_description ...; Created on 25 January 2016
2. MySQL Updating a database table from another table: / MySQL /; What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they ...; Created on 22 October 2014
3. Convert to Proper Case in T-SQL: / Transact-SQL /; ... DECLARE @i INT; DECLARE @c VARCHAR(2); -- specify reset SELECT @Reset = 1, @i=1, @Ret = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, ...; Created on 04 June 2014
4. Reorder Columns in a Table: / Databases /; ... `Column2` varchar(100) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`Column1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- To CREATE TABLE IF NOT EXISTS ...; Created on 22 July 2013
5. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... DISTINCT ' + LTRIM(@ColToProcess) + ' COLLATE ' + @p_UseCollation + ', ''' + LTRIM(@ColToProcess) + ''', ...; Created on 26 October 2012
6. Search a database with SOUNDEX: / Databases /; ... Cursor1 CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column_value, ''' + TABLE_SCHEMA + '.' ...; Created on 11 October 2012
7. T-SQL example of Case-Sensitive Soundex: / Transact-SQL /; ... other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results: SELECT ...; Created on 10 October 2012
8. Search a database for a string (MySQL, T-SQL): / Databases /; ... You can put a distinct on it (not forgetting the collate). This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE @SqlToExecute nvarchar(max); DECLARE ...; Created on 08 October 2012
9. Documentation Introduction: / Documentation /; I'm going to be putting all the articles which document my downloadable products. Please bear with me as I collate all your questions and go into more detail; Created on 12 September 2010