在oracle数据库中插入西班牙语单词的问题
有没有办法将西班牙语单词插入 Oracle 表中 - 例如“España”。
当我尝试插入它时，它要么采用它的 ASCII 对应项，要么用“?”替换“ñ”。
有人以前做过这个或者知道解决方法吗？
我在谷歌搜索时发现了一些东西，他们告诉我们必须在 init.ora 文件中提及西班牙语字符集。我不知道如何执行此操作，也不知道如何为客户端设置 nls_settings。我正在使用蟾蜍连接到位于英国的服务器。
请帮助我解决这个问题。
Is there a way to insert spanish words into the Oracle table - like 'España'.
When I try to insert it, it either takes the ASCII counterpart of it or replaces the 'ñ' with a '?'.
Has anyone done this before or knows a work around for it?
I found something while googling they told we have to mention spanish character set in init.ora file. I don't know how to do this and also setting nls_settings for client. I am using toad to connect to server which is located in UK.
Please help me in solving this problem.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
首先，您应该检查数据库创建时使用的字符集是否包含您要插入的西班牙语字符。对于从 9i 开始的 Oracle 版本，向导默认使用 Unicode 创建数据库，因此这应该不是问题。但是，如果数据库不是由您创建的，那么首先应该向创建该数据库的 DBA 进行检查。
您连接到哪个版本的 Oracle 服务器？
您使用的是哪个版本的 Oracle 客户端？哪种 Oracle 客户端（OCI、JDBC、.NET）？
如果数据库创建正确，则可能是与客户端平台相关的问题。
如果没有有关客户端操作系统、您正在使用的数据库客户端库及其与自然语言支持相关的配置的信息，诊断起来并不容易。
因此，我将向您介绍与此问题相关的 Oracle 常见问题解答。需要阅读的材料很多，但值得您花时间。
http://www.oracle.com/technetwork/database/globalization /nls-lang-099431.html
First, you should check if the database was created with a character set that includes the Spanish characters that you want inserted. For versions of Oracle starting with 9i the wizards by default create the database using Unicode, so it shouldn't be a problem. But if the database wasn't created by you, this should be the first thing to check with the DBA that created it.
Which version of the Oracle server are you connecting to?
Which version of the Oracle client are you using? Which kind of Oracle client (OCI, JDBC, .NET)?
If the database was properly created it can be a problem related to the client platform.
And this is not simple to diagnose without information about the client OS, database client libraries that you are using and their configurations related to Natural Language Support.
So, I will point you to an Oracle FAQ related to this issue. It is a lot of material to read but it worths your time.
http://www.oracle.com/technetwork/database/globalization/nls-lang-099431.html