SQL Strings Truncating at 255 Characters ? Why?

  • Thread starter Thread starter SetiRich
  • Start date Start date
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?
 
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?
 
Back
Top