MaksymBilenko / docker-oracle-12c

:whale: Docker image with Oracle Database 12c on board
Apache License 2.0
679 stars 285 forks source link

ORA-29275:partial multibyte character #161

Closed wtujvk closed 2 years ago

wtujvk commented 2 years ago

Use the command: docker run -d --name myoracle -p 8080:8080 -p 1521:1521 -v /my/oracle/data:/u01/app/oracle -e ORACLE_ALLOW_REMOTE=true -e ORACLE_CHARACTERSET=al32utf8 -e DBCA_TOTAL_MEMORY=2048 quay.io/maksymbilenko/oracle-12c

And when It has Chinese characters, It call 'ORA-29275:partial multibyte character' The client is Navicat15.0.11, oracle server in Centos7+docker.

image

Use this command docker run -d -p 1521:1521 --name oracle11g registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g, It Ok, but oracle_11g are not supported Table names with 30 characters.


使用docker命令行启动oracle-12c, 可以创建容器。 但是有的表查询会报错。本地window10, 服务器centos7+docker+quay.io/maksymbilenko/oracle-12c 网上查询资料说是编码问题,但是设置了还是无效。 使用oracle-11c可以安装成功,不会报这个错, 但是oracle-11不支持表名超过30个字符。

MaksymBilenko commented 2 years ago

Try to set $CHARACTER_SET env variable Detailed configuration you could check here: https://github.com/MaksymBilenko/docker-oracle-12c/blob/master/entrypoint.sh#L17

wtujvk commented 2 years ago

image