Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utf-8 encoding on windows 10 with sql.exe

user499562Jun 26 2018 — edited Jun 26 2018

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 xy@test

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

This post has been answered by cormaco on Jun 26 2018
Jump to Answer
Comments
Post Details
Added on Jun 26 2018
1 comment
1,078 views