Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How can I change my MySQL collation in WAMPSERVER

Tags:

mysql

wampserver

How can I change my MySQL collation in WAMPSERVER from latin1_swedish_ci to UTF-8 because I think my HTML special characters are getting all messed up

like image 437
stacks Avatar asked Aug 13 '10 02:08

stacks

1 Answers

put in your C:\wamp\bin\mysql\mysql5.5.24\my.ini:

character-set-server=utf8    
collation-server=utf8_general_ci
like image 77
matyig Avatar answered Sep 18 '22 04:09

matyig

Sign in to Comment

Related questions

Insert or update (if exists) without primary key
How to create a Sequelize model instance, without saving it in the database?
How to get data from database to view page in laravel?
how to recover mysql password in ubuntu 16.04
Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
How to write raw query in Laravel
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
com.mysql.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library
Random ids in sqlalchemy (pylons)
No duplicates in SQL query
How to get the greatest of two columns values in MySQL?
Want Row Number on Group of column in MY SQL?
Multiple MYSQL queries vs. Multiple php foreach loops
How can I store PHP code inside of a mysql table
How to include the mysql header?
Adding database results to array
Read a text file and transfer contents to mysql database
Should you do validation checks that go outside the possiblility of normal user activity?
MySQL "IS IN" equivalent?
How do I create a database if it doesn't exist, using PHP?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!