Posted on 2006-03-28
Last Modified: 2008-02-01
How do I stop the "latin1_swedish ci collation" going into my tables when I load my sql files into phpmyadmin?
I don't have it set in any of my sql files.
I have apache/mysql/php/perl/phpmyadmin set up on my windows xp computer

there must be a delfault stting some place I can change?

Wht is the english setting?
Question by:starview
    LVL 30

    Accepted Solution

    You probably want ascii_general_ci collation.

    You can set the default collation at a server level in the my.ini file in C:\Program Files\MySQL\MySQL Server 5.0 folder (this is the default installtion folder for 5.0).


    Note that this won't change the collation for the existing tables - you may need to either reimport them (making sure they don't specify a collation in the CREATE TABLE script) or explicitly alter the tables using ALTER TABLE tableName SET COLLATE=ascii_general_ci;

    LVL 30

    Expert Comment

    Thanks for the points!

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now