English 中文(简体)
DB 中比 UU 更大的甲骨字符串
原标题:Oracle string in DB larger than on UI

有一个字符串,它来自文本字段,有200个字符限制。在 Offacle DB s table 中,字段的最大值为200个字符。应用程序崩溃,它说它无法将212个字符写入最多200个字符的字段。问题明显出现在 DB 级别上,与其他带有相同表格和 CRUD 的数据库一样,它都运行良好。

我怀疑这个问题可能与编码差异有关,

SELECT * 来自NLS_DATABASE_PARameters;

两个数据库的结果都相同,在两种情况下,NLS_CHARACTERSET 都显示了AL32UTF8 的价值。有什么问题?

P. S. 它是 ASP. NET 应用程序,如果有帮助的话。

最佳回答

如果 NLS_LENCHTH_SEMENTICS 参数相同, 也许对列的定义不同: VARCHAR2( 200 BYTE) 和 VARCHAR2( 200 CHAR)?

呵呵。 呵呵。

亚历山德罗

问题回答

暂无回答




相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

How to Add script codes before the </body> tag ASP.NET

Heres the problem, In Masterpage, the google analytics code were pasted before the end of body tag. In ASPX page, I need to generate a script (google addItem tracker) using codebehind ClientScript ...

Transaction handling with TransactionScope

I am implementing Transaction using TransactionScope with the help this MSDN article http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx I just want to confirm that is ...

System.Web.Mvc.Controller Initialize

i have the following base controller... public class BaseController : Controller { protected override void Initialize(System.Web.Routing.RequestContext requestContext) { if (...

Microsoft.Contracts namespace

For what it is necessary Microsoft.Contracts namespace in asp.net? I mean, in what cases I could write using Microsoft.Contracts;?

Separator line in ASP.NET

I d like to add a simple separator line in an aspx web form. Does anyone know how? It sounds easy enough, but still I can t manage to find how to do it.. 10x!

热门标签