MySQL Forums
Forum List  »  Newbie

Re: Searching database for strings with Swedish characters
Posted by: Rick James
Date: December 12, 2013 04:11PM

Recommend using a cmd window (if you are in Windows), and typing
That will bring you to this prompt:
which will let you type and execute SQL statements such as
USE db_name; -- fill in with the name of the TNG database
SHOW CREATE TABLE tbl_name; -- the name of the table.
Then identify which column has the characters that are in trouble, and do
SELECT col_name, HEX(col_name) FROM tbl_name;
You may need a WHERE clause on the end to limit it to the one row in question. See if this helps:
SELECT col_name, HEX(col_name) FROM tbl_name WHERE col_name LIKE '%llstad%';

This discusses more than you want to know about problems like yours:

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.