Jump to content

UTF8 problem


dugasz1

Recommended Posts

  • Moderators

You just changed the encoding type of the communications between your script and the sql server to UTF-8 for the current connection (theMysql).

Because ASCII encoding can't handle your special characters.

Link to comment
  • Moderators

1 - Log into phpMyAdmin.

2 - Select your database.

3 - Click on "Operations" from the top set of tabs.

4 - In the Collation box, choose your new collation from the dropdown menu. utf8_general_ci is the most common utf8 collation/encoding.

5 - Click on Execute/Run button.

And then you need to repeat the same operations but on all tables already created (which doesn't have the right collation/encoding).

(And maybe for columns of all tables, not sure if they will be updated)

The next tables you will create will get the database collation as default so you will be ok.

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...