SQL Strings Truncating at 255 Characters ? Why?

S

SetiRich

I was under the impression that max length for a string would be approx. 64k
characters. For some reason my strings are truncating at 255 characters, thus
limiting my query lenth severely.

I'm using Off. Pro. 2007 on Server2003 & accessing MySQL backend.

Any clues why this is happening?
 
B

Bob Barrows

SetiRich said:
I was under the impression that max length for a string would be
approx. 64k characters. For some reason my strings are truncating at
255 characters, thus limiting my query lenth severely.

I'm using Off. Pro. 2007 on Server2003 & accessing MySQL backend.

Any clues why this is happening?
Click to expand...

Perhaps it's a limitation of the ODBC driver you are using?
Where are you seeing this truncation occur? Do you experience it with
passthrough queries? Or solely with linked tables?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Table Query Truncating Memo Field at 255 Characters 2
Jet Truncating Excel Data at 255 Characters 0
String Variable Truncating At 255 Chars 3
Excel Data Truncated to 255 Characters 0
Union Query and Memo Felds - truncating at 255 characters 1
Access ADP Truncating Characters in SQL Table 1
Problems saving record to a SQL Server via VBA 4
copy cell contents to a textbox > 255 characters 7

Top