Forums » General Discussion

Thread: UTF in Result Sets column Names

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 5 - Pages: 1 - Last Post: Jan 3, 2013 10:38 PM by: blokva
blokva

Posts: 4
Registered: 3/5/12
UTF in Result Sets column Names
Posted: Mar 5, 2012 6:16 AM
 
  Click to reply to this thread Reply

Help me please!
When I put an alias for column in my SQL Query (SELECT MyColumn as 'Проверка' from MyBase) in the Foreign language (Russian for me), I see symbols shown on the picture. Any ideas?





Mauritz

Posts: 314
Registered: 8/23/07
Re: UTF in Result Sets column Names
Posted: Mar 5, 2012 9:07 AM   in response to: blokva
 
  Click to reply to this thread Reply

Do you have a character set that is different from UTF-8 in your database?


blokva

Posts: 4
Registered: 3/5/12
Re: UTF in Result Sets column Names
Posted: Mar 6, 2012 7:19 AM   in response to: Mauritz
 
  Click to reply to this thread Reply

No I haven't
BTW in PHPMyAdmin I have no problems with column names in Russian

ps: All data in UTF from tables are shown in grid correctly. Problem is only with column Names in grid
Message was edited by: blokva

pps: sorry for my English
Message was edited by: blokva


blokva

Posts: 4
Registered: 3/5/12
Re: UTF in Result Sets column Names
Posted: Mar 13, 2012 12:24 AM   in response to: blokva
 
  Click to reply to this thread Reply

I suppose the column Names aren't in UTF code! May be there is a workaround way?



Guy_M

Posts: 26
Registered: 2/16/11
Re: UTF in Result Sets column Names
Posted: Apr 5, 2012 8:13 AM   in response to: blokva
 
  Click to reply to this thread Reply

Hi,

I've the same kind of problem in statement when I rename the column.

If I write something like "select ColumnName as NomAccentué ..." the column header displayed is "NomAccentué" disgracious :-(

It's work fine in PhpMyAdmin.

Any idea, is there any parameter in the editor ?

Best regards
GM



blokva

Posts: 4
Registered: 3/5/12
Re: UTF in Result Sets column Names
Posted: Jan 3, 2013 10:38 PM   in response to: blokva
 
  Click to reply to this thread Reply

Bad news: in the last beta this problem doesn't solved yet!
But in the same situation column name looks differently:





Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums