Access 'memo' data type - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Access 'memo' data type

Access 'memo' data type# Database - 数据库

l*l2003-03-28 08:03

1 楼

Tricky question. There is a table in access 2000 which has a column with type
memo. The long (>255) length string is stored in that column. If I write a sql
in access to retrieve it, the length of the string returned is correct. The
insteresting thing is that when I write the sql in java application and
retrieve it through ODBC, the length of the string returned will be truncated
to 255 no matter how long it was.
My code is like:
...
Statement stmt = con.createStatement();
ResultSet rs = stmt.ex

g*o2003-03-28 08:03

2 楼

I got exactly the same problem when i was doing a project with Access as
backend and ASP as frontend. the tricky topics here is
1). Donot include DISTINCT keyword in your SQL statement, otherwise, an error
will be thrown.
2). Try to address MEMO field as the last column in your SQL statement.
or
3) Seperate your SQL statement into two. For example,
select other_field1, other_field2 from **** ; and select memo_field from ****
;
instead of select * from ****;

type
sql
truncated

【在 l*********l 的大作中提到】

: Tricky question. There is a table in access 2000 which has a column with type
: memo. The long (>255) length string is stored in that column. If I write a sql
: in access to retrieve it, the length of the string returned is correct. The
: insteresting thing is that when I write the sql in java application and
: retrieve it through ODBC, the length of the string returned will be truncated
: to 255 no matter how long it was.
: My code is like:
: ...
: Statement stmt = con.createStatement();
: ResultSet rs = stmt.ex