Re: FN-FORUM: Displaying part of a site in Mandarin

date posted 7th March 2008 11:25


On 7 Mar 2008, at 12:20, Martin Wheatley wrote:

>
> On 07/03/2008 12:16, Mark Boylan wrote:
>> On 7 Mar 2008, at 11:56, Anthony Cartmell wrote:
>>> UTF-8
>> Brilliant Thanks for the advice
>> Mark
>
> Make sure everything is UTF-8 including the database if it's required.
>
> There's nothing worse than finding out you have to redo a load of
> stuff as it wasn't stored correctly in the database and is coming
> out as garbage ;)


this is a good starting point for getting to grips with UTF-8

http://www.nicknettleton.com/zine/php/php-utf-8-cheatsheet

if you're using PHP/MySQL it's also worth the boot and braces
approach of making sure your database connection is UTF-8, so right
after connecting the database and before issuing any sql queries do:

mysql_query("SET NAMES utf8");
mysql_query("SET CHARACTER_SET utf8");


hth

;o)