相当于varchar2？ [英] equivalent of varchar2?

问题描述

大家好，


访问VARCHAR2相当于什么？


谢谢

hilz

解决方案

VARCHAR-2 ????

-

PC数据表

您的资源以获取Access，Excel和Word应用程序的帮助
re ***** *@pcdatasheet.com
www.pcdatasheet.com

" hilz" <无** @ y.com>在消息中写道

新闻：0L ******************** @ comcast.com ...

你好所有，

访问VARCHAR2的等价物是什么？

感谢
hilz

> VARCHAR-2 ????


有没有像VARCHAR-2这样的东西????

包含我的问题不清楚，这里有一些更多详细信息：


在Oracle中，有一种名为VARCHAR2的数据类型。它可以保持超过该字段的

长度。

例如;

创建表测试（名称VARCHAR（10））;

现在如果你在这个表中插入一行名称=''一个字符串更长

超过10个字符''

它会接受它并存储它。我相信长度（10）只是为了优化

，并且应该接近你期望的那个字段中的大部分值。


如果你在表格中插入一行名为'''abc''的行，它就不会用空格填充

字符串，从而节省了存储空间。 />

现在在Access中，声明一个字段作为CHAR将具有固定长度

不能超过，如果该值短于长度，则

填充空格以填充整个场地长度，这不是

非常可取。


如果我创建我的访问表使用的是SQL语句，而不是表格

设计器，我可以将字段设置为VARCHAR，但不能设置为VARCHAR2。

和VARCHAR在这种情况下不会填充带有空格的短字符串，这是好的，但它不允许字符串长于列宽。

所以我的问题是：是否有这样的数据类型n访问类似于

VARCHAR2？


我记得有备忘录提交，但我也记得它不是
$ b建议将$ b用于任何字符串字段。


感谢

hilz

" hilz" <无** @ y.com>在消息中写道

新闻：0L ******************** @ comcast.com ...

你好所有，

访问VARCHAR2的等价物是什么？

hilz

Text 。

Hi all,

What is the equivalent of VARCHAR2 in access?

thanks
hilz

解决方案

VARCHAR-2 ????

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"hilz" <no**@y.com> wrote in message
news:0L********************@comcast.com...

Hi all,

What is the equivalent of VARCHAR2 in access?

thanks
hilz

> VARCHAR-2 ????

Is there such a thing as VARCHAR-2 ????
Incase my question was not clear, here are some more details:

In Oracle, there is a datatype called VARCHAR2. It can hold more than the
length of the field.
for example ;
create table test (name VARCHAR(10));
Now if you insert into this table a row with name=''a string that is longer
than 10 characters''
it will accept it and store it. I beleive the length (10) is just for
optimizing, and should be close to what you expect most of the values in
that field to be.

And if you insert into the table a row with name=''abc'' it will not pad the
string with spaces, and thus saving storage space.

Now in Access, declaring a filed as CHAR will have a fixed length that
cannot be exceeded, and if the value was shorter than the length, it is
padded with spaces to fill the whole length of the field, and that is not
really very desirable.

If i create my access table using an SQL statement, rather than the table
designer, i can set the field as VARCHAR, but not VARCHAR2.
and VARCHAR in this case does not pad the short string with spaces, which is
good, but it does not allow a string that is longer than the column width.
so my question is: is there such a datatype in Access that is similar to
VARCHAR2?

I remember there was a memo filed, but I also remember that it is not
recommended to use that for just any string field.

thanks
hilz

"hilz" <no**@y.com> wrote in message
news:0L********************@comcast.com...

Hi all,

What is the equivalent of VARCHAR2 in access?

thanks
hilz

Text.

这篇关于相当于varchar2？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！