Output window and chinese characters

25 views
Skip to first unread message

Petr #peksha#

unread,
Nov 13, 2014, 4:23:51 AM11/13/14
to vorax-...@googlegroups.com
Hi,
I have problem with chinese characters in Vorax output window. If I try to execute

select '在该商店中' from dual;

I become this error:
Error detected while processing function vorax#output#FetchAndSpit...#vorax#ruby#SqlplusReadOutput:
line 12:
ArgumentError: invalid byte sequence in UTF-8

Is this caused by my settings? I have to read records from databases with utf-8 encoding, that contains chinese characters.

Thanks

talek

unread,
Nov 13, 2014, 7:27:58 AM11/13/14
to vorax-...@googlegroups.com
Hi,

before starting Vorax/Vim ensure you have the environment properly setup:

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORA_NCHAR_LITERAL_REPLACE=true

Below is the output from my Vorax:

14:23:59 SQL> select N'在该商店中' from dual;

U'\5728\8BE5\5546\5E
--------------------
在该商店中

Elapsed: 00:00:00.01

Also, please make sure you use the latest Vorax version from github.

Petr #peksha#

unread,
Nov 19, 2014, 8:19:53 AM11/19/14
to vorax-...@googlegroups.com
Hi,

thanks, settings of NLS_LANG was the problem...
Reply all
Reply to author
Forward
0 new messages