Member Avatar for aamna@daniewb

what collation to use for storing english and French in phpmyadmin(MYSQL)
I am using collation "utf8_general_ci", but some french characters are not stored properly in database
e.g. "É" is stored as "É"

  • 2 Contributors
  • 1 Reply
  • 131 Views
  • 43 Minutes Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for cereal

For the table use:

default charset = utf8 collate utf8_general_ci

then change the charset of the form sending the data:

<form accept-charset="utf8" action="" method="post">

and it should work fine. If this is not enough then change the configuration of Apache by adding:

AddDefaultCharset UTF-8

More information: http://httpd.apache.org/docs/2.2/mod/core.html#adddefaultcharset

EDIT
Wondering: the problem is related only to PHPMyAdmin? Could be your browser encoding.

Edited by cereal
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.