Linked Questions
28 questions linked to/from How can I find non-ASCII characters in MySQL?
1
vote
1
answer
5k
views
MySQL Regex for Non English Characters [duplicate]
I've looked all over Stack-Overflow and Google for a simple REGEX for MySQL that satisfies the following requirements:
Finds all rows with a Non English Characters (ö, etc)
Match any part of the ...
- 2,539
0
votes
1
answer
941
views
mySql - find non-Ascii character in html [duplicate]
I'm trying to find all non-asci characters I have in my DB in a specific table and column. In that column are stored Html description, and in some of them I've exotic or non-existing characters (for ...
- 2,183
1
vote
0
answers
364
views
How do I search for strings containing accented characters in SQL? [duplicate]
I have a table called x with column LegalName since they are over 10K+, I want to write a query that returns me names that have accents. (á, é, í, ó, ú, ü, ñ). Is there a better way other than ...
- 797
117
votes
5
answers
121k
views
Trouble with UTF-8 characters; what I see is not what I stored
I tried to use UTF-8 and ran into trouble.
I have tried so many things; here are the results I have gotten:
???? instead of Asian characters. Even for European text, I got Se?or for Señor.
Strange ...
- 144k
4
votes
4
answers
15k
views
Remove Hidden Non-ASCII Characters [PHP or MySQL]
I'm having a problem with hidden non-ASCII characters (spaces) in my database.
How can I replace them with normal spaces and convert them before being inserted to avoid future problems?
I'm still ...
- 275
3
votes
2
answers
6k
views
How can I find the Non keyboard characters in MySQL?
Related question to How can I find non-ASCII characters in MySQL?.
I want to check for col1 and col2 in my table given below for the cases where non keyboard characters are present.
+------------+---...
- 4,079
3
votes
2
answers
10k
views
REGEXP not working in mysql
I am trying to find record with names which have non-alpha numeric characters.
I thought that I could do it with REGEXP
http://dev.mysql.com/doc/refman/5.1/en/regexp.html
Then I referred another SO ...
- 5,289
2
votes
1
answer
4k
views
How to identify a language in utf-8 column in MySQL
My question is how to find specific character set from utf-8 column in MySQL server?
Please note that this is NOT Duplicate question, please read carefully what's asked, not what's you think.
...
- 31
2
votes
2
answers
1k
views
How to check if a row in a table has muti-byte characters in it in a MySQL database?
I have a table which has column of descr which stores string values. Some of the values in descr has multi-byte characters in it and I want to know all those rows so I can remove those characters. How ...
- 2,033
1
vote
2
answers
3k
views
MySQL Full Text Period
I have a table of product names, and full text works great up until using a period, e.g. searching for a 3.7 battery.. i try
select .. where match(name) against ('+3.7v +battery' in boolean mode)
i ...
- 13
0
votes
1
answer
2k
views
Select Query to Remove these characters in Mysql
SELECT *
FROM mytablename
WHERE sku = 'AZ-EFCQ-5'
LIMIT 0 , 30
In MySQL table (description field) there are some weird characters in the database.There are almost 400+ records with all these ...
- 5,467
0
votes
4
answers
2k
views
SELECT to match special characters and case
Field X in table may contain special characters e.g hello!World and I would like to know if there is a way to match that with HelloWorld (Ignore case and special characters).
SELECT * FROM table WHERE ...
- 2,598
3
votes
1
answer
791
views
How to select data with REGEXP without containing Extended ASCII
I just want to display data with :
containing a-z
containing A-Z
contain numbers 0-9
contain printable ASCII charachter on the following link http://www.theasciicode.com.ar/extended-ascii-code/latin-...
- 207
0
votes
2
answers
838
views
MySQL Replace Part of String (Longtext)
After a CONCAT from various other fields, I am trying to clean up the data - specifically removing multiple separators... but it affects 0 records (out of several thousand.)
UPDATE CONTACTS
SET NOTES ...
- 145
2
votes
3
answers
650
views
Escaping Hindi Characters in mysql
I'm trying to fetch data from database using MySQL, the table has some entries in hindi, I'm looking to filter out those hindi results in google sheets automatically by running SQL queries in google ...
