migrate from MySQL 3 to MySQL 5

I have a problem migrating to a newer version on MySQL.

The problem is the codepage. I need to be able to store croatian
characters into db. èæšðž


MySQL 3 was installed by a previous programmer in my company. I don't
know anything about administrating mysql (other then Navicat GUI) so I
need help.
During an instalation of MySQL5 i had a choice of codepages... i
selected latin 2 (since that is central europian) but instead of èæšðž
the DB remembers ??š?ž

How can i change the codepage from console?



Thanks

--

Re: migrate from MySQL 3 to MySQL 5

> MySQL 3 was installed by a previous programmer in my company. I don't
> know anything about administrating mysql (other then Navicat GUI) so I
> need help.
> During an instalation of MySQL5 i had a choice of codepages... i
> selected latin 2 (since that is central europian) but instead of èæ=
šð=9E
> the DB remembers ??=9A?=9E
>=20
> How can i change the codepage from console?

If you are talking about character sets check this part of the manual:
http://dev.mysql.com/doc/refman/5.0/en/character-sets.html

Note that you are probably specifically looking at the following=20
character set:
http://dev.mysql.com/doc/refman/5.0/en/charset-cp932.html

Mike Willbanks
Zend Certified Engineer
http://blog.digitalstruct.com

Re: migrate from MySQL 3 to MySQL 5

Mike Willbanks wrote:

> > MySQL 3 was installed by a previous programmer in my company. I
> > don't know anything about administrating mysql (other then Navicat
> > GUI) so I need help.
> > During an instalation of MySQL5 i had a choice of codepages... i
> > selected latin 2 (since that is central europian) but instead of
> > èæšðž the DB remembers ??š?ž
> >
> > How can i change the codepage from console?
>
> If you are talking about character sets check this part of the manual:
> http://dev.mysql.com/doc/refman/5.0/en/character-sets.html
>
> Note that you are probably specifically looking at the following
> character set:
> http://dev.mysql.com/doc/refman/5.0/en/charset-cp932.html
>
> Mike Willbanks
> Zend Certified Engineer
> http://blog.digitalstruct.com

thanks

--