Collation, does it matter?

Archived from the Xataface Users forum.

Aoirthoir — Mon Jun 12, 2006 6:20 am

There are options in myPHPadmin for Collation on tables and Collation on fields. Generally does it matter? Since I can choose not to fill such options. The programs Ive been using for data conversion fill them for me usually as latin1_swedish_ci on the table and column level.

---

shannah — Mon Jun 12, 2006 7:54 am

This page explains it pretty well http://www.informit.com/articles/article.asp?p=328641&rl=1
In practical terms, I have never paid much attention to them… the default collation seems to work for every case that I have run across. Perhaps you would want to use a different collation if you were storing chinese or japanese text though.

---

Pedja — Wed Dec 27, 2006 9:51 am

Ohyes it does matter. If you stick with english that it does not. I have problems using Dataface on database that is not in english.

Option to set collation for database connection is a must.

---

shannah — Thu Dec 28, 2006 4:39 pm

This thread is quite old - prior to dataface’s multilingual additions in 0.6.

What kinds of problems are you having with non-english dbs? I am currently using Dataface on chinese, japanese, korean, french, and english databases without a problem.

-Steve