Collation

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
visonardo
Forum Contributor
Posts: 136
Joined: Mon Oct 02, 2006 7:49 pm
Location: Argentina, South America´s Sun.

Collation

Post 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?
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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
User avatar
visonardo
Forum Contributor
Posts: 136
Joined: Mon Oct 02, 2006 7:49 pm
Location: Argentina, South America´s Sun.

Post by visonardo »

Thank volka :D
Post Reply