UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 that language set. I needed to make my extension read data from a MySQL database and display the caracters as intended with UTF8. I tried enough extensions and forum solutions, and although these changes would have an effect on the module (such as take...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 NOT EXISTS `Table1` ( `Column1` int(11) NOT NULL AUTO_INCREMENT, `Column3` int(11) NOT NULL, `Column2` varchar(100) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`Column1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout); $data = utf8_decode(curl_exec($ch)); // note the utf8_decode function applied here curl_close($ch); return $data; } $file_content =...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 use to encode queries sent to the server. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; CharSet=UTF8; Note that resultsets still are returned in the character set of the data returned. Specifying shared memory name Use this...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 nothing: // add the following to your header This does nothing: // set the collation of the database and any text fields to 'utf8-general-ci' ALTER DATABASE db_name CHARACTER SET latin1 COLLATE utf8-general-ci; // set text fields to utf8 SET NAMES...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

MySQL Updating a database table from another tablehttps://joellipman.com/articles/database/mysql/mysql-updating-a-database-table-from-another-table.html

22 October 2014 it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b ON a.`CountryName` COLLATE utf8_general_ci LIKE b.`CountryName` COLLATE utf8_general_ci SET a.`ccTLD` = b.`ccTLD`

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 characters rather than bytes. - Fixed bug: renamed functions so as not to conflict with any pre-existing ones (eg. utf8_strlen) - Date Uploaded: Thu, 28th Oct 2010 1.2.2- Corrected PHP code to work in earlier PHP versions. - Fixed bug: could not see...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *