Malayalam language datas not visible

[expired user #9101]'s profile image [expired user #9101] posted 9 years ago in General Permalink
While viewing databases(MySQL) table contents , fields containing malayalam language datas are not seen but at the same time mysql-query-browser is able view it. how it can be solved !
ansgar's profile image ansgar posted 9 years ago Permalink
* What's the collation of the fields containing the malayalam contents?
* How does it look like - can you please attach a screenshot here?
[expired user #9101]'s profile image [expired user #9101] posted 9 years ago Permalink
I am quoting the query I used to create the database , table and values ; so you too can do at your end to verify. And also I 'm attaching the screenshots of using the heidisql and mysqlQueryBrowser as well. please see the difference.

create database language default character set utf8 collate utf8_unicode_ci;
create table NAMES(name varchar(30) NULL);
insert into NAMES values('രാകേഷ്');
insert into NAMES values('ആദിതാ');
insert into NAMES values('ആനംദ');


2 attachment(s):
  • heidi
  • mysqlQueryBrowser
ansgar's profile image ansgar posted 9 years ago Permalink
Looks fine here. See attached image.

I guess you need to select another font for the data grid, which is probably not capable of displaying all characters. See Tools > Preferences > Text formatting.
1 attachment(s):
  • data-malayalam
[expired user #9101]'s profile image [expired user #9101] posted 9 years ago Permalink
Oh , Yea . I have checked it . I changed the grid font to "Rachana" and now its showing quite fine.
Very thanks for the recommendations.

I do have one request, please do create a linux compatible installation application , rather than forcing wine to use under Linux distribution to Heidisql , since this is a very wonderful application which only lacks this.

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