Posted on 2006-03-28
Medium Priority
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
  • 2
LVL 30

Accepted Solution

todd_farmer earned 2000 total points
ID: 16318266
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

ID: 16318692
Thanks for the points!

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month14 days, 9 hours left to enroll

840 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