Changing Collation for SQL Server 2008 R2 Express

Last Updated on Saturday, 2 July 2011 02:38 Written by Ian McIntosh Friday, 1 July 2011 12:00

This article builds on the previous post and is part of a series to setup local and remote working environments for MojoPortal.

Background

If you have differing collations on your local and remote databases, you are likely at some stage to see collation errors.

Checking Collation of Your MojoPortal Databases

Last Updated on Thursday, 30 June 2011 01:18 Written by Ian McIntosh Thursday, 30 June 2011 12:00

This article builds on the previous post in the series about how to setup local and remote working environments for MojoPortal.

Background

Collation settings in SQL Server affects character set, sort order and case sensitivity.

Creating a Remote MojoPortal SQL Database

Last Updated on Thursday, 30 June 2011 01:18 Written by Ian McIntosh Wednesday, 29 June 2011 12:00

This article builds on the previous post in this series, providing a step-by-step guide to setting up local and remote environments for MojoPortal.

In this post, I will walk you through creating a remote database, by which I mean creating a new MS SQL database on your hosting account.

This is a pretty straight forward task, but there are a couple of things to watch out for. For this reason, I give it a post of its own.

How to Change the Collation of a Database in phpMyAdmin

Last Updated on Friday, 25 June 2010 11:08 Written by Arian Jahansouz Friday, 25 June 2010 11:08

This article will give you a step by step guide on how to change the collation of one of your databases using phpMyAdmin. Sign into your cPanel and follow these steps:

1) Scroll down to Databases and click phpMyAdmin