oracle 创建实例定义编码格式

灰太狼 2024-04-17 17:03 74阅读 0赞

oracle 创建实例的时候可以指定编码格式UTF-8 ,默认是GBK

启动database configuration assistant，创建数据库，参照下面的图释。

[![format_png][]][format_png 1]

[![format_png 2][]][format_png 2 1]

这里指定数据库名和实例名，根据自己想要的设置，这里是举例啦

[![format_png 3][]][format_png 3 1]

[![format_png 4][]][format_png 4 1]

可以统一的口令，也可以选上面的选项进行逐一设置

[![format_png 5][]][format_png 5 1]

[![format_png 6][]][format_png 6 1]

[![format_png 7][]][format_png 7 1]

[![format_png 8][]][format_png 8 1]

可以在这里设置字符集，后面的步骤默认即可。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1b3d3MQ_size_16_color_FFFFFF_t_70][]

然后一步一步点击即可完成。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1b3d3MQ_size_16_color_FFFFFF_t_70 1][]

查看oracle数据库编码

select \* from nls\_database\_parameters where parameter = 'NLS\_CHARACTERSET';

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9nc3MwLmJhaWR1LmNvbS85Zm8zZFNhZ194STRraEdrbzlXVEFuRjZoaHkvemhpZGFvL3doJTNENjAwJTJDODAwL3NpZ249ODY4YTczY2U4MjBhMTlkOGNiNTY4YzAzMDNjYWFlYjMvNjQzODBjZDc5MTIzOTdkZGViNzFiMjdiNWI4MmIyYjdkMGEyODc0MC5qcGc?x-oss-process=image/format,png
[format_png 1]: https://gss0.baidu.com/9fo3dSag_xI4khGko9WTAnF6hhy/zhidao/pic/item/64380cd7912397ddeb71b27b5b82b2b7d0a28740.jpg
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9nc3MwLmJhaWR1LmNvbS8tdm8zZFNhZ194STRraEdrbzlXVEFuRjZoaHkvemhpZGFvL3doJTNENjAwJTJDODAwL3NpZ249YThmMTVmN2I5NTBhMzA0ZTUyNzdhOGZjZTFmODhiYmUvMzBhZGNiZWY3NjA5NGIzNmY5NDEzMDkyYTFjYzdjZDk4YzEwOWRmOS5qcGc?x-oss-process=image/format,png
[format_png 2 1]: https://gss0.baidu.com/-vo3dSag_xI4khGko9WTAnF6hhy/zhidao/pic/item/30adcbef76094b36f9413092a1cc7cd98c109df9.jpg
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9nc3MwLmJhaWR1LmNvbS85Zm8zZFNhZ194STRraEdrbzlXVEFuRjZoaHkvemhpZGFvL3doJTNENjAwJTJDODAwL3NpZ249NjNiNDk1NWM2MTI3NjJkMDgwNmJhY2I5OTBkYzI0YzIvNDNhN2Q5MzNjODk1ZDE0MzY3MTNjZTVjNzFmMDgyMDI1YWFmMDc2My5qcGc?x-oss-process=image/format,png
[format_png 3 1]: https://gss0.baidu.com/9fo3dSag_xI4khGko9WTAnF6hhy/zhidao/pic/item/43a7d933c895d1436713ce5c71f082025aaf0763.jpg
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9nc3MwLmJhaWR1LmNvbS8tUG8zZFNhZ194STRraEdrbzlXVEFuRjZoaHkvemhpZGFvL3doJTNENjAwJTJDODAwL3NpZ249YTg5N2RjYjJmZTAzOTI0NWExZTBlOTA5YjdhNDg4ZmEvZTYxMTkwZWY3NmM2YTdlZmE1NDI4MjU5ZmZmYWFmNTFmM2RlNjY2Yy5qcGc?x-oss-process=image/format,png
[format_png 4 1]: https://gss0.baidu.com/-Po3dSag_xI4khGko9WTAnF6hhy/zhidao/pic/item/e61190ef76c6a7efa5428259fffaaf51f3de666c.jpg
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9nc3MwLmJhaWR1LmNvbS8tZm8zZFNhZ194STRraEdrbzlXVEFuRjZoaHkvemhpZGFvL3doJTNENjAwJTJDODAwL3NpZ249NWQ2Y2IzZTAyY2RkYTNjYzBiYjFiMDI2MzFkOTE1MzkvM2M2ZDU1ZmJiMmZiNDMxNjdiNzg1MDA1MjJhNDQ2MjMwOWY3ZDM2ZC5qcGc?x-oss-process=image/format,png
[format_png 5 1]: https://gss0.baidu.com/-fo3dSag_xI4khGko9WTAnF6hhy/zhidao/pic/item/3c6d55fbb2fb43167b78500522a4462309f7d36d.jpg
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9nc3MwLmJhaWR1LmNvbS85NG8zZFNhZ194STRraEdrbzlXVEFuRjZoaHkvemhpZGFvL3doJTNENjAwJTJDODAwL3NpZ249YWQwY2ZhOTJlNTExOTBlZjAxYWU5YWQ5ZmUyYmIxMmUvNmE2M2Y2MjQ2YjYwMGMzM2FmN2RmNGI3MTg0YzUxMGZkOWY5YTE0Yy5qcGc?x-oss-process=image/format,png
[format_png 6 1]: https://gss0.baidu.com/94o3dSag_xI4khGko9WTAnF6hhy/zhidao/pic/item/6a63f6246b600c33af7df4b7184c510fd9f9a14c.jpg
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9nc3MwLmJhaWR1LmNvbS85Zm8zZFNhZ194STRraEdrbzlXVEFuRjZoaHkvemhpZGFvL3doJTNENjAwJTJDODAwL3NpZ249ZTY2OTk4MGJlOWY4MWE0YzI2NjdlNGNmZTcxYTRjNjEvMzgxMmIzMWJiMDUxZjgxOTZjNDIyOTM1ZDhiNDRhZWQyZTczZTc2ZS5qcGc?x-oss-process=image/format,png
[format_png 7 1]: https://gss0.baidu.com/9fo3dSag_xI4khGko9WTAnF6hhy/zhidao/pic/item/3812b31bb051f8196c422935d8b44aed2e73e76e.jpg
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9nc3MwLmJhaWR1LmNvbS8tZm8zZFNhZ194STRraEdrbzlXVEFuRjZoaHkvemhpZGFvL3doJTNENjAwJTJDODAwL3NpZ249MzE4ZDM4MzA5YzJmMDcwODVmNTAyMjA2ZDkxNDk0YTEvMGZmNDFiZDVhZDZlZGRjNGU3ODE5ZTg0M2JkYmI2ZmQ1MjY2MzM2ZS5qcGc?x-oss-process=image/format,png
[format_png 8 1]: https://gss0.baidu.com/-fo3dSag_xI4khGko9WTAnF6hhy/zhidao/pic/item/0ff41bd5ad6eddc4e7819e843bdbb6fd5266336e.jpg
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1b3d3MQ_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/9bbdb586cd58457694c37064b02e99e2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1b3d3MQ_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/f73d99f2dbc54290b90c3f46dd8247ad.png