I have installed MySQL 5.0.24a-community-nt on my PC. When I add a new
table (via phpMyAdmin) varchar columns are assigned a collation charset
of latin1_swedish_ci. This does not look right to me. On my ISP (running
MySQL 3.23) I do not even get a choice for collation charset.

In my.ini, I have "default-character-set=latin1" set in both the Client
and Server sections.

What do I need to tweak on my PC to get it to behave more like my ISP
(as far as character sets are involved)? I realize the difference in
MySQL versions might present some difficulties.

I'd me happy to provide more config info, just let me know what to
provide.

Thanks,

--

Dennis K.

On Sun, 12 Nov 2006 10:47:36 -0500, Dennis K. <nobody@iglou.invalid>
wrote:

>I have installed MySQL 5.0.24a-community-nt on my PC. When I add a new
>table (via phpMyAdmin) varchar columns are assigned a collation charset
>of latin1_swedish_ci. This does not look right to me. On my ISP (running
>MySQL 3.23) I do not even get a choice for collation charset.
>
>In my.ini, I have "default-character-set=latin1" set in both the Client
>and Server sections.
>
>What do I need to tweak on my PC to get it to behave more like my ISP
>(as far as character sets are involved)? I realize the difference in
>MySQL versions might present some difficulties.
>
>I'd me happy to provide more config info, just let me know what to
>provide.

Upon further review, it looks like what I might be seeing has more to do
with phpMyAdmin settings then it does with the MySQL config.

Never mind.

--

Dennis K.