CODEWITHSUNDEEP
mysqlconcatenation
Thiyagu
Thiyagu

Reputation: 786

Use Euro symbol in MySql query

How to use euro symbol in MySql concat() function?

Below I tried but it prints only text whatever.

SELECT CONCAT(tab1.amount,'&euro') FROM tab1

Anyhelp appreciated.

Upvotes: 0

Views: 751

Answers (1)

MarcM
MarcM

Reputation: 2251

&euro HTML entity can't be used in MySQL. Use standard ascii sign instead:

SELECT CONCAT(tab1.amount, _ucs2 0x20AC) AS t
FROM tab1;

Note: _ucs2 is for using UCS-2 Unicode Encoding

Upvotes: 3

Related Questions