How to code mySQL connection with utf-8

Question

Well I have created a page in Dreamweaver where I use phpMyAdmin as a database. My page can read Swedish letters which are written in Dreamweaver without any problems but when it retrieves data from the database (phpMyAdmin), it gets wrong. Instead of the Swedish letters it says �. I have encoded with utf- 8

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

Also the file is saved as utf-8 and I'm using Google Chrome which uses utf 8.

I've heard that I have to encode the connection with the database with utf-8 also, but I don't know how to do that?

As far as I know the way I connect is by:

<?php require_once('Connections/Audiologiska.php'); ?>

Grateful for answers!

Keo · Accepted Answer · 2014-07-14 23:53:49Z

1

Don't forget set charset after connecting to db php mysql charset. Also check if columns has right charset.

answered Jul 14, 2014 at 23:53

Keo

1,1518 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pbs · Accepted Answer · 2014-07-14 23:55:12Z

0

On the connection file/class normally i put:

SET NAMES utf8;

And for the database collation i choose utf8_general_ci

answered Jul 14, 2014 at 23:55

pbs

2483 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to code mySQL connection with utf-8

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related