Posted:
Mon Jun 12, 2006 6:20 amby Aoirthoir
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.
Posted:
Mon Jun 12, 2006 7:54 amby shannah
This page explains it pretty well
http://www.informit.com/articles/article.asp?p=328641&rl=1In 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.
Posted:
Wed Dec 27, 2006 9:51 amby Pedja
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.
Posted:
Thu Dec 28, 2006 4:39 pmby shannah
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