up vote 0 down vote favorite
share [g+] share [fb]

I previously asked this Q: utf8 hebrew on mysql console on debian (via putty on windows)
And managed to get it working by starting mysql with --default-character-set=utf8 and setting putty to show utf8 as well.

Now I need to do the same but on a windows server. The data is again the same but when I start mysql with --default-character-set=utf8 it I see multuple characters where I am supposed to see hebrew.

I think the problem is with the set up of windows cmd console that it does not properly display utf8.

any ideas ?

link|improve this question
75% accept rate
I ended up using phpmyadmin for those things where I need to see the hebrew... – epeleg Mar 21 '11 at 16:31
feedback

3 Answers

up vote 2 down vote accepted

Not being able to process Unicode characters is a known limitation of mysql command line client. It is addressed in Worklog#5331, which will make it into MySQL5.6 (or whatever version MySQL next will be). 5.5 should already support a weaker form of i18n (guessing console codepages as in Worklog#1349).

link|improve this answer
just to clarify, this means that i have nothing to do about it. can't access unicode data via command line on windows? – epeleg Mar 19 '11 at 22:39
1  
Not in interactive mode (that is, not until MySQL5.6 is out). The only way to use unicode characters in released version is non-interative (having text file with queries encoded in utf8 and use file redirection, i.e mysql --default-character-set=utf8 < script.sql ) – Vladislav Vaintroub Mar 20 '11 at 1:55
feedback
up vote 1 down vote

My (admittedly limited) experience with Hebrew on Windows is that you need an actual Hebrew-localized build of Windows for it to work at all well. I have almost always had to move files to Linux to work with them, for example. And even if you get Hebrew to display, many programs will treat it as L-to-R instead of R-to-L.

link|improve this answer
well, it feels kind of ridiculous that I can see hebrew when connecting from my windows to a linux server but not when talking to my own windows machine. – epeleg Mar 14 '11 at 13:17
1  
@epeleg: You are using different software to connect to the Linux server. PuTTY's terminal emulator (which is itself emulating Xterm) is much more advanced than the built-in Win32 Console. – grawity Mar 14 '11 at 22:20
feedback
up vote 0 down vote

You can change codepages with the chcp command. Multibyte UTF-8 is codepage 65001, but its support is flaky. (For example, I tried using Python with 65001 selected, and it outright crashes on any output.)

  • Make sure you are using the correct font, too.

If nothing else works, use the old console codepages.

The Hebrew codepage for console ("OEM") is chcp 862 (--default-character-set=cp862) and the "ANSI" one is chcp 1255. Make sure you have them installed under Regional and Language Options – Advanced – Code page conversion tables.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.