Hi people,
I have a question about setting default charset in MySQL. I am asking this because following: I have an Access database file, and I want to import 2 tables from it in MySQL. For that purposes I am using Navicat. It exports fine the structure of mdb file, but the problem is that it has much fields with croatian characters, and after process of importing, I see strange characters where I expect to see croatian ones. I know that default charset latin1 and collation latin1_swedish_ci. I made a query CREATE DATABASE `base` DEFAULT CHARACTER SET latin2 COLLATE latin2_croatian_ci; but again after importing tables into that db, it is the same problem. I CAN change that chars manually in table, but it is much of work to change all. My question is simple: Is it possible to set default charset to latin2 and collation to latin2_croatian_ci applying it in the same time to all db which will be created?

I wouldn't know the answer to that.. I'm not very experienced with charsets and all. The best bet I would guess would be to go onto the MySQL forums, at: http://forums.mysql.com/, and post your question there. You willmost likely get your question(s) fully answered there.
Sorry,
-NedreN