mysql query special characters

Question

What is the query to determine character set of the MySQL Database ? Or is there a way to determine it.

How to query special characters (non-UTF8) characters from a column ?

SELECT * FROM tableName WHERE column .....

This might help you [Mysql Selecting String with Special Characters](http://stackoverflow.com/questions/6603132/mysql-selecting-string-with-special-characters) — Subedi Kishor, Mar 18 '13 at 06:43

score 0 · Accepted Answer · edited May 23 '17 at 12:21

0

There is already a question related to this question..

Heres a link to another question here in stackoverflow that can give you hints or tricks How to see what character set a database / table / column is in MySQL? click here

edited May 23 '17 at 12:21

Community

1
1

answered Mar 18 '13 at 06:41

Jhonathan H.

2,734
1
19
28

score 0 · Answer 2 · answered Mar 18 '13 at 06:43

I tried a direct way with regex which didnt work much. The other solution that i found is this:

select * from tablename
where columnname regexp(concat('[',char(128),'-',char(255),']'));

As for the character set you can use

select DEFAULT_CHARACTER_SET_NAME FROM information_schema.SCHEMATA;

mysql query special characters

2 Answers2