View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 09:33 AM
Dennis K.
 
Posts: n/a
Default Help with character sets and collation?

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.
Reply With Quote