cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefania (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-11030) utf-8 characters incorrectly displayed/inserted on cqlsh on Windows
Date Mon, 01 Feb 2016 05:13:39 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-11030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15125765#comment-15125765
] 

Stefania edited comment on CASSANDRA-11030 at 2/1/16 5:12 AM:
--------------------------------------------------------------

The latest changes are +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.



was (Author: stefania):
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)

Mime
View raw message