<![CDATA[PunBB Forums — UTF-8, the final solution...]]> https://punbb.informer.com/forums/topic/9146/utf8-the-final-solution/ Sat, 03 May 2008 22:18:20 +0000 PunBB <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/114349/#p114349 wow. thanks all for these... really valuable input!

]]> Sat, 03 May 2008 22:18:20 +0000 https://punbb.informer.com/forums/post/114349/#p114349 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/96887/#p96887 coolhd wrote:

I have a discussion about using MySQL4.1 with UTF-8, and you can see some snapshot in that article.
Sorry for the snapshot was in chinese,but you can see something keyword.

http://img.photobucket.com/albums/v197/ … ysql41.jpg

1. modify table "search_words" , and change the field "word" type from "varchar" to "varbinary".


2. edit file "/include/dblayer/common_db.php"
add:

$db->query("SET NAMES 'UTF8'");

in the last line,then save it.

3.done.

THAT'S IT !!!

It worked for me - I work with french caracters - àéèêç

THANKS !

]]> Fri, 22 Jun 2007 15:50:13 +0000 https://punbb.informer.com/forums/post/96887/#p96887 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/78293/#p78293 Long post with PHP/MySQL/Unicode issues discussed here: http://forums.mysql.com/read.php?103,97854,99266

]]> Sat, 30 Sep 2006 10:22:29 +0000 https://punbb.informer.com/forums/post/78293/#p78293 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/78220/#p78220 Luhmann wrote:

I can't understand why the "English" language file is not set to UTF-8, as is now standard with just about every other PHP script I use (Wordpress, Wikimedia, etc.). Please change this!

Exactly!

]]> Fri, 29 Sep 2006 10:15:10 +0000 https://punbb.informer.com/forums/post/78220/#p78220 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/70608/#p70608 yehaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
big problem --- little solution
thanks so mutch

]]> Mon, 12 Jun 2006 11:26:28 +0000 https://punbb.informer.com/forums/post/70608/#p70608 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/64113/#p64113 I can't understand why the "English" language file is not set to UTF-8, as is now standard with just about every other PHP script I use (Wordpress, Wikimedia, etc.). Please change this!

]]> Sun, 05 Mar 2006 07:41:31 +0000 https://punbb.informer.com/forums/post/64113/#p64113 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/61882/#p61882 Jérémie wrote:

No, it work with MySQL <4.1. Textpattern does it for example. MySQL doesn't simply understand what he is storing, but that doesn't matter.

That's not entirely true. Sorting of the user list for example, will be off.

]]> Tue, 07 Feb 2006 09:40:43 +0000 https://punbb.informer.com/forums/post/61882/#p61882 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/61867/#p61867 No, it work with MySQL <4.1. Textpattern does it for example. MySQL doesn't simply understand what he is storing, but that doesn't matter.

]]> Tue, 07 Feb 2006 01:45:28 +0000 https://punbb.informer.com/forums/post/61867/#p61867 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/61839/#p61839 One of the "limitation" with UTF-8 is that MySQL <4.1 doesn't support it. Right?

]]> Mon, 06 Feb 2006 16:36:56 +0000 https://punbb.informer.com/forums/post/61839/#p61839 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/61837/#p61837 I have tried UTF-8 for lithuanian language - doesn't work

]]> Mon, 06 Feb 2006 15:40:51 +0000 https://punbb.informer.com/forums/post/61837/#p61837 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/55544/#p55544 UTF-8 is the way to go!

cheers Pos3idon! smile

]]> Fri, 28 Oct 2005 08:42:43 +0000 https://punbb.informer.com/forums/post/55544/#p55544 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/55283/#p55283 No limitations. UTF-8 *is* the way to go. We are several petitioning Rickard to make it the default charset of PunBB tongue

]]> Tue, 25 Oct 2005 18:30:51 +0000 https://punbb.informer.com/forums/post/55283/#p55283 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/55273/#p55273 no I think there will be no limitations on utf-8 - btw. your that drkadjija from mi3 smile nice to see you m8 smile

]]> Tue, 25 Oct 2005 16:43:04 +0000 https://punbb.informer.com/forums/post/55273/#p55273 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/55156/#p55156 It works, I'm just wondering if there are any limitations using utf-8...

]]> Mon, 24 Oct 2005 10:19:25 +0000 https://punbb.informer.com/forums/post/55156/#p55156 <![CDATA[Re: UTF-8, the final solution...]]> https://punbb.informer.com/forums/post/55028/#p55028 Did you mean this problem "Unable to insert search index words" ??

Then how about this thread : http://punbb.org/forums/viewtopic.php?id=5882

I modify table field's type to solve that problem. (I'm using Chinese in UTF-8 now,and it works fine for my forum.)

]]> Sun, 23 Oct 2005 04:05:39 +0000 https://punbb.informer.com/forums/post/55028/#p55028