[ https://issues.apache.org/jira/browse/CASSANDRA-11030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15125765#comment-15125765 ]
Stefania commented on CASSANDRA-11030: -------------------------------------- The latest changes +1. Unfortunately it still doesn't work on one of the win7 machines. On the other one it works perfectly though. I think there is something wrong with the python installation since I cannot even get it to print Unicode characters in the python shell either even though the terminal font supports it. Here are the exact commands from a command prompt but similar results happen with a power shell prompt. Running the command prompt as an elevated user did no help either. {code} Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\stefania>cd git\cstar\cassandra C:\Users\stefania\git\cstar\cassandra>cd bin C:\Users\stefania\git\cstar\cassandra\bin>chcp Active code page: 437 C:\Users\stefania\git\cstar\cassandra\bin>chcp 65001 Active code page: 65001 C:\Users\stefania\git\cstar\cassandra\bin>type ..\unicode.cql INSERT INTO test.test (bla ) VALUES ('não') ; C:\Users\stefania\git\cstar\cassandra\bin>cqlsh.bat --help Usage: cqlsh.py [options] [host [port]] CQL Shell for Apache Cassandra Options: --version show program's version number and exit -h, --help show this help message and exit -C, --color Always use color output --no-color Never use color output --browser=BROWSER The browser to use to display CQL help, where BROWSER can be: - one of the supported browsers in https://docs.python.org/2/library/webbrowser.html. - browser path followed by %s, example: /usr/bin /google-chrome-stable %s --ssl Use SSL -u USERNAME, --username=USERNAME Authenticate as user. -p PASSWORD, --password=PASSWORD Authenticate using password. -k KEYSPACE, --keyspace=KEYSPACE Authenticate to the given keyspace. -f FILE, --file=FILE Execute commands from FILE, then exit --debug Show additional debugging information --encoding=ENCODING Specify a non-default encoding for output. If you are experiencing problems with unicode characters, using utf8 may fix the problem. (Default from system preferences: cp1252) --cqlshrc=CQLSHRC Specify an alternative cqlshrc file location. --cqlversion=CQLVERSION Specify a particular CQL version (default: 3.3.1). Examples: "3.0.3", "3.1.0" -e EXECUTE, --execute=EXECUTE Execute the statement and quit. --connect-timeout=CONNECT_TIMEOUT Specify the connection timeout in seconds (default: 5 seconds). --request-timeout=REQUEST_TIMEOUT Specify the default request timeout in seconds (default: 10 seconds). -t, --tty Force tty mode (command prompt). Connects to 127.0.0.1:9042 by default. These defaults can be changed by setting $CQLSH_HOST and/or $CQLSH_PORT. When a host (and optional port number) are given on the command line, they take precedence over any defaults. C:\Users\stefania\git\cstar\cassandra\bin>cqlsh.bat Connected to Test Cluster at 127.0.0.1:9042. [cqlsh 5.0.1 | Cassandra 2.2.4-SNAPSHOT | CQL spec 3.3.1 | Native protocol v4] Use HELP for help. cqlsh> select * from test.test ; val ----- no n?o (2 rows) cqlsh> quit C:\Users\stefania\git\cstar\cassandra\bin>cqlsh.bat --encoding=utf-8 Connected to Test Cluster at 127.0.0.1:9042. [cqlsh 5.0.1 | Cassandra 2.2.4-SNAPSHOT | CQL spec 3.3.1 | Native protocol v4] Use HELP for help. cqlsh> select * from test.test ; val ----- no n?o (2 rows) cqlsh> quit C:\Users\stefania\git\cstar\cassandra\bin>cqlsh.bat --encoding=cp65001 Connected to Test Cluster at 127.0.0.1:9042. [cqlsh 5.0.1 | Cassandra 2.2.4-SNAPSHOT | CQL spec 3.3.1 | Native protocol v4] Use HELP for help. cqlsh> select * from test.test ; val ----- no n?o (2 rows) cqlsh> {code} I think we should commit this as it works on the majority of machines and it looks like a Python problem only one one machine. A repair reinstall of Python did not help. I did not do a clean reinstall because I need to run more tests today and I don't want to loose all the ccm dependencies but I can try again to reinstall python completely later. > utf-8 characters incorrectly displayed/inserted on cqlsh on Windows > ------------------------------------------------------------------- > > Key: CASSANDRA-11030 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11030 > Project: Cassandra > Issue Type: Bug > Reporter: Paulo Motta > Assignee: Paulo Motta > Priority: Minor > Labels: cqlsh, windows > > {noformat} > C:\Users\Paulo\Repositories\cassandra [2.2-10948 +6 ~1 -0 !]> .\bin\cqlsh.bat > --encoding utf-8 > Connected to test at 127.0.0.1:9042. > [cqlsh 5.0.1 | Cassandra 2.2.4-SNAPSHOT | CQL spec 3.3.1 | Native protocol v4] > Use HELP for help. > cqlsh> INSERT INTO bla.test (bla ) VALUES ('não') ; > cqlsh> select * from bla.test; > bla > ----- > n?o > (1 rows) > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)