SQL字段字符限制 [英] SQL field character limit

问题描述

您好我在SQL Server 2008中将表格字符限制为255并且我使用Ms Access 2007表单来添加数据。表格有字段，即产品描述开始变得奇怪，不允许我输入超过47个字符。

Hi I've my table character limit to 255 in SQL server 2008 and I'm using Ms Access 2007 forms to add data. The form has got field ie Product description that started to act strange by not allowing me to put more than 47 characters.

 

我有检查了我服务器上的字段属性，它们仍然是255但是Access一直将我限制为最小字符。

I have checked the field properties on my server and they are still 255 but Access kept on limiting me to minimal character.

 

请帮助。

推荐答案

您可以触发SQL Server探查器来验证向SQL Server发送什么命令以插入（更新）您的表吗？

Can you fire SQL Server profiler to verify what command is send to SQL Server to insert (update) your table?

这篇关于SQL字段字符限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！