导出Oracle表在插入语句中显示本地(Bangla)语言数据的未识别符号
我正在出口一张包含一些孟加拉信息的桌子。如果我运行选择的语句数据,则显示良好,但如果将其导出为SELECT UTF-8或UTF8编码,则该编码显示一些未认识的符号。如果我选择一些不同的编码,则显示“ ???”而不是孟加拉字母。
我缺少什么。请帮忙。
Oracle DB:Oracle Database 19C Enterprise Edition版本19.0.0.0.0-生产
SQL开发人员:Java(TM)平台1.8.0_291 Oracle IDE 21.2.1.2.1.2.1.204.1703版本版本21.2.1.2.1.2.1.204.1703
在下面添加了一些屏幕。
使用SQL开发人员使用UTF8或UTF-8导出后,其显示不认识的字符。
I am exporting a table that contains some Bangla information. If I run select statement data is showing fine but if export it as select UTF-8 or UTF8 encoding this is showing some unrecognize symbol. if I choose some different encoding it shows "???" instead of Bangla letter.
what I am missing. Please help.
Oracle DB : Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Sql developer : Java(TM) Platform 1.8.0_291 Oracle IDE 21.2.1.204.1703 Versioning Support 21.2.1.204.1703
Addes some screenshot below.
Select query showing bangla data fine. But...
After exporting using sql developer using UTF8 or UTF-8 its showing unrecognise characters.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
值得庆幸的是,这些数据已成功导出!以前,我右键单击桌子并选择导出选项,然后窗口出现。我必须选择编码选项的地方。
但是这次我从窗口中选择了压缩的复选框选项。它创建一个zip文件,并在内部找到脚本。哇!我的数据很好!
现在正在工作!
Thankfully those data are exported successfully! previously I right-clicked on the table and select export option then a window came up. where I had to choose encoding option.which was giving the issues with data.
But this time I selected compressed check box option from the window. It creates a zip file and inside that found the script. and wow! my data is showing fine!
Now it's working!