Re: Proper display of special latin1 characters in Powershell / MySql client ?
Posted by: Abraham Guyt
Date: March 27, 2011 09:50PM

Hi Rick,

Thanks for replying ! I went through the recommended reading and tried a few tests that just should return basic UTF8 characters from the mysql cli client, thus bypassing any database specific issues.

1st try:
- Windows7x64 using command prompt and chcp 65001 (UTF8 code page) and font Lucida Console
- using MySQL server 5.5.9
- issued 'set names utf8' with mysql cli

- statement: select _utf8 x'C3A9' as col1, char_length(_utf8 x'C3A9') as col2

This statement should display the e-acute character, and have a UTF8 string length of 1.

The results of that statement show for col1 TWO squares, and for col2 the correct value of 1. Apparently the two bytes for the e-acute character cannot be shown correctly using these settings.

When using the MySQL Query Browser the statement above gives the correct results.

Using the mysql cli client on code page 1252 and with a latin1 connection also gives the correct results.

Using powershell instead of the command prompt gives identical results.

Any ideas why this doesn't work ? Any UTF8 display from the mysql cli client output to a windows shell (wich UTF8 code page) still seems to undisplayable.

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.