distal-attribute
distal-attribute
distal-attribute
distal-attribute

show strings as UTF/Unicode

safineh posted 1 week ago in General

Hi, query results that contains UTF/Unicode strings shown as ASCII. Is any way to choose correct or default encoding for display.

Note: data encoding is NOT incorrect. I can see my data correctly in app. TIA

1 attachment(s):
  • hsql
kalvaro posted 7 days ago

Even if your data encoding is correct, could you please post a screenshot of the "Create table" tab that displays the column encoding and the result of running this query?

SELECT HEX(name), HEX(owner)
FROM your_table_here

Thank you!

safineh posted 6 days ago

I don't need hex of strings, I need Unicode rather that ASCII. the result that I get in web, and the result I get from HeidiSQL are attached. in web in use <meta charset="UTF-8"> in <head>

and this is my create code:

CREATE TABLE alarm ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, time DATETIME NOT NULL, text VARCHAR(128) NULL DEFAULT NULL, PRIMARY KEY (id), ) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=40 ;

2 attachment(s):
  • wsql
  • hsql
safineh posted 6 days ago

this is what i get from HeidiSQL:

1 attachment(s):
  • hsql
kalvaro posted 5 days ago

Sorry then, I was just trying to help.

ansgar posted 4 days ago

Probably a font issue. Try to use a more modern font, in Tools > Preferences > Data

safineh posted 4 days ago

Sorry then, I was just trying to help. thanks kalvaro

safineh posted 4 days ago

Probably a font issue. Try to use a more modern font, in Tools > Preferences > Data

the web output and the HeidieSQL output are using a same font: Tahoma. ????

Misha v.3 posted 4 days ago

Could you provide results of the following queries: show variables like 'character%'; show variables like 'collation%';

Misha v.3 posted 4 days ago

Err. Cannot update mu post to make the code more readable. Here you are:

show variables like 'character%';
show variables like 'collation%'

Please login to leave a reply, or register at first.