<![CDATA[PunBB Forums — *help* How to change collation??]]> https://punbb.informer.com/forums/topic/18204/help-how-to-change-collation/ Thu, 07 Feb 2008 13:52:16 +0000 PunBB <![CDATA[Re: *help* How to change collation??]]> https://punbb.informer.com/forums/post/109082/#p109082 Empty those tables and rebuild the search index.

]]> Thu, 07 Feb 2008 13:52:16 +0000 https://punbb.informer.com/forums/post/109082/#p109082 <![CDATA[Re: *help* How to change collation??]]> https://punbb.informer.com/forums/post/109081/#p109081 Thanks! It works now.. The only row that I cant change is search_words/word

ALTER TABLE `search_words` CHANGE `word` `word` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL

MySQL: Documentation
#1062 - Duplicate entry 'prevoyance' for key 1
]]> Thu, 07 Feb 2008 13:46:03 +0000 https://punbb.informer.com/forums/post/109081/#p109081 <![CDATA[Re: *help* How to change collation??]]> https://punbb.informer.com/forums/post/108456/#p108456 Yes, put a ; after each one and run them in phpMyAdmin or the MySQL CLI tool.

]]> Fri, 01 Feb 2008 12:52:24 +0000 https://punbb.informer.com/forums/post/108456/#p108456 <![CDATA[Re: *help* How to change collation??]]> https://punbb.informer.com/forums/post/108451/#p108451 Jérémie wrote:

and then the same for every table, like
ALTER TABLE `pun13_categories`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
And then, maybe row by row (where it's useful).

Is it enought to do this command or do I have to do this command for the tables under also?
Like:

bans
      username
      ip
      email
      message

Jérémie wrote:

Much simpler to set it up at the database level, then install PunBB.

Which means?

Jérémie wrote:

If your forum is in Farsi, Swedish, French, Spanish, or others, the collation isn't the same. Look at the utf8_ collate available, if your language isn't one of them utf8_general_ci is probably the best one for you.

Ok I understand. My forum is in Swedish, is latin1_swedish_ci a good choice or shall I use utf8_swedish_ci?

]]> Fri, 01 Feb 2008 09:49:15 +0000 https://punbb.informer.com/forums/post/108451/#p108451 <![CDATA[Re: *help* How to change collation??]]> https://punbb.informer.com/forums/post/108361/#p108361 Aren't username case sensitive?

Anyway, the best collation depend on your language. If your forum is in Farsi, Swedish, French, Spanish, or others, the collation isn't the same. Look at the utf8_ collate available, if your language isn't one of them utf8_general_ci is probably the best one for you.

You simply need to alter it for your database: 

ALTER DATABASE `your db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

for example,

and then the same for every table, like 

ALTER TABLE `pun13_categories`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

And then, maybe row by row (where it's useful).

Much simpler to set it up at the database level, then install PunBB.

]]> Thu, 31 Jan 2008 17:38:39 +0000 https://punbb.informer.com/forums/post/108361/#p108361 <![CDATA[*help* How to change collation??]]> https://punbb.informer.com/forums/post/108359/#p108359 Hi my collation in the database in right now at UTF-8_bin. This cause my big problem because the forum cant se the different in BIG and small letters. Thats means serveral things dont work.

People cant log in with    "Staffan" if there username is "staffan"
Author search do not work,  you cant search for peoples topic if the got a big letter in there name.
ect...


So if Im right the best collation to use is utf8_general_ci..

How do I change my tables in the database to utf8_general_ci instead of UTF-8_bin?

]]> Thu, 31 Jan 2008 17:21:58 +0000 https://punbb.informer.com/forums/post/108359/#p108359