How can I use special characters in MySQL

Question

How can I insert special characters like ♣ and é into a sql table? When I try it I get the error below:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '] ♣ us3rnamé', '123456789', 'http://blabla.com/blabla/', 'http://' at line 1

The data type is text. I guess that shouldn't matter.

I don't see how this would help me. – Manticore May 13 '13 at 15:29 — Manticore, May 13 '13 at 15:29

score 0 · Answer 1 · answered May 13 '13 at 03:02

0

You probably need to tell the database you want to use a different character set. Try sending a query with SET NAMES 'utf8' right after you connect, and before you insert anything.

answered May 13 '13 at 03:02

Steven V

16,357
3
63
76

score 0 · Accepted Answer · answered May 13 '13 at 09:41

0

Try addslashes in php documentation

answered May 13 '13 at 09:41

Pruthvi Raj Nadimpalli

1,335
1
15
30

I tried but it doesn't add slashes in front of ♣ – Manticore May 13 '13 at 15:27
Ah now I get it. It was no matter of ♣. It was a matter of one ' Thanks so much! – Manticore May 13 '13 at 15:37

How can I use special characters in MySQL

2 Answers2