Forum Stats

  • 3,758,931 Users
  • 2,251,475 Discussions
  • 7,870,440 Comments

Discussions

utf-8 encoding on windows 10 with sql.exe

user499562
user499562 Member Posts: 3
edited Jun 26, 2018 9:39AM in SQLcl

Hello,

I'm testing the sqlcl on windows 10, and I can't type french  or german characters like "éöäüè" etc in the sql.exe console.

V:\>sql.exe -V

SQLcl: Release 18.1.1.0 Production

V:\>chcp

Active code page: 65001

sql.exe [email protected]

SQL> show encoding

Encoding:windows-1252

SQL> set encoding utf-8

SQL> show encoding

Encoding:UTF-8

Using a select in a table doesn't show them either, the characters are ignored like:

something like "d'étudiants" is displayed as "d'tudiants"

And, as mentionned previously I cannot type any international character in the sql.exe console either.

If I go back into cmd.exe I can type them:

SQL>!

Microsoft Windows [Version 10.0.17134.112]

(c) 2018 Microsoft Corporation. All rights reserved.

V:\>chcp

Active code page: 65001

V:\>éàöü

Any ideas how I can fix the problem, as sql.exe is unusable right now for me?

Many thanks,

Didier

Best Answer

  • cormaco
    cormaco Member Posts: 1,682 Bronze Crown
    edited Jun 26, 2018 9:21AM Accepted Answer

    I have better results when I set the encoding in cmd to 1252 and leave sql.exe to Windows-1252:

    SQL> version

    Oracle SQLDeveloper Command-Line (SQLcl) Version: 18.1.0.0

    SQL> select 'öäüÖÄÜ߀' as demo from dual;

    DEMO

    --------

    öäüÖÄÜ߀

Answers

  • cormaco
    cormaco Member Posts: 1,682 Bronze Crown
    edited Jun 26, 2018 9:21AM Accepted Answer

    I have better results when I set the encoding in cmd to 1252 and leave sql.exe to Windows-1252:

    SQL> version

    Oracle SQLDeveloper Command-Line (SQLcl) Version: 18.1.0.0

    SQL> select 'öäüÖÄÜ߀' as demo from dual;

    DEMO

    --------

    öäüÖÄÜ߀