central european collation?

[knucklehead]

hello
i must admit that i still cannot make clear to myself the thing with collation of sql tables... if all my pages are in ISO-8859-2 charset, which collation type should i set in mysql?? there are few types of 'croatian' collation but i'm not sure which is right for me? =) also i want to ask what is the difference between collation of the whole table and each field? i'm reading this on dev.mysql.com but i don't understand nothing there =)

thank you for your patience =)

[NogDog]

From this page, looks like you should use charset "latin2" and collation "latin2_croation_ci".

As far as table/field difference, it's just a case where if no field-level collation is specified, then the table-level collation is used, and if none is specified for the table then the database's collation is used.

Also, it's likely that you may need to tell MySQL what character set you'll be using, so after connecting you'll want to submit the following query before doing any other queries:

mysql_query("SET NAMES 'latin2' COLLATE 'latin2_croatian_ci'");