Categories > TinyButStrong general >

Vietnamese Unicode doesn't work on TBS.

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Andy
Date: 2007-09-18
Time: 20:03

Vietnamese Unicode doesn't work on TBS.

this is what I wrote:
$TBS->LoadTemplate(index.tpl","UTF-8") ;

Shouldn't this work on vietnamese character?
you can view my website, look on the right panel, you will see some weird characters showing. But when you click on it, in the forum, it works fine.

What am I missing here? Please help me. Thanks.

Andy
By: Andy
Date: 2007-09-18
Time: 20:04

Re: Vietnamese Unicode doesn't work on TBS.

oh yeah, my website is: www.bonmua.net/mediacenter
By: Skrol29
Date: 2007-09-19
Time: 13:13

Re: Vietnamese Unicode doesn't work on TBS.

Hi,

They are TbsSQL error messages on this web page. And no data item is merged.
By: Andy
Date: 2007-09-19
Time: 16:37

Re: Vietnamese Unicode doesn't work on TBS.

Sorry, I just moved my host to to www.freeeh.com. Please check it out again. Thanks for you help.
By: Skrol29
Date: 2007-09-20
Time: 21:46

Re: Vietnamese Unicode doesn't work on TBS.

Hi,

I've reproduced your problem.
It is not because of TBS, but because of the way MySQL is producing the UTF8 string when you connect to it. By default, it is ISO and not UTF8. This means that by default MySQL is giving to you all data converted into ISO chars.

You can ask MySQL to send UFT8 characters by sending the SQL command:
SET NAMES 'utf8'

I've seend from a previous page that you are using TbsSQL. The exampl
e below worked fine for me:
$Db = new clsTbsSQL('localhost','root','','test');
$Db->Execute("SET NAMES 'utf8'"); // This will make MySQL to speak to you in UTF8.

$TBS = new clsTinyButStrong;
$TBS->LoadTemplate('test.html','UTF-8');
$TBS->MergeBlock('b','tbssql','SELECT * FROM t_test_utf8');
$TBS->Show();
By: Andy
Date: 2007-09-21
Time: 03:42

Re: Vietnamese Unicode doesn't work on TBS.

Thanks for your helpful reply. I'll try it now. Thanks
By: Andy
Date: 2007-09-21
Time: 03:47

Re: Vietnamese Unicode doesn't work on TBS.

It works. Thank  you so much. I've been pulling my hair out for this.