Page 1 of 1

Collation

Posted: Sat Mar 10, 2007 2:08 pm
by visonardo
I need help with that, collation specification of text, varchar field of my db. I need use portuguece characters and spanish like "ñ" and others, or the "ç" and others specials chars. wich one would you recomend me?

I have my db with latin1_swedish_ci, the default. and has like 5000 rows, what happen if i change now (with the data inside) this value?

Posted: Sat Mar 10, 2007 3:51 pm
by volka
I'd try latin1 as charset and latin1_general_ci as collation.
visonardo wrote:I have my db with latin1_swedish_ci, the default. and has like 5000 rows, what happen if i change now (with the data inside) this value?
see http://dev.mysql.com/doc/refman/5.0/en/ ... rsion.html

Posted: Wed Mar 14, 2007 4:50 pm
by visonardo
Thank volka :D