...the SQL Query Tool that was designed with you in mind
Get Productive Today!
Home | Product Features | Screenshots | Videos | Download\Purchase | Support Forum | About

Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
Results Column Width limited to 255?
Options View
Previous Topic Next Topic
DavidGriffiths Offline
#1 Posted : Monday, July 26, 2010 4:20:35 PM
Rank: Member

Medals:

Groups: Member
Joined: 9/16/2009
Posts: 12
Location: Vancouver

Thanks: 1 times
Was thanked: 0 time(s) in 0 post(s)
Hi,

I've just written a script that runs against a Sybase database that generates a bunch of insert statements (to be executed against a SQL Server database).

The result of the query is a column that is approx 300 characters in size; QweryBuilder is truncating it at 254 columns. I've looked to see if I can re-direct the output to a text file, or if I can increase the width (the Options dialog, and looked in the help file) but I've found nothing.

I've tried copying and pasting (hoping that the copy and paste would grab the additional text), and saving the results as a file, in the hope of getting all the data out.

Is there any way around the 255-character limitation?

David
Back to top
Report?
Sponsor  
 
Werysoft's QweryBuilder
Back to top  
bradwery Offline
#2 Posted : Monday, July 26, 2010 4:40:39 PM
Rank: Administration

Medals:

Groups: Administration
Joined: 2/5/2009
Posts: 84
Location: Manitoba, Canada

Thanks: 0 times
Was thanked: 3 time(s) in 3 post(s)
There is a 32k limit to what can be retrieved for a single column. It shouldn't be truncating to 254 characters. Could the database be doing this perhaps? Can you reproduce this with scripts that I can run?
Brad Wery
Lead Architect
Back to top
WWW BLOG
Report?
DavidGriffiths Offline
#3 Posted : Monday, July 26, 2010 4:46:39 PM
Rank: Member

Medals:

Groups: Member
Joined: 9/16/2009
Posts: 12
Location: Vancouver

Thanks: 1 times
Was thanked: 0 time(s) in 0 post(s)
You are correct- I went to add a test query, and this message appeared.

"Character or binary data returned from Adaptive Server has been truncated. The client application does not support more than 255 bytes of data as a result column or output parameter."

It only appeared when I had two queries returning two different result sets.

Thanks for the response.

David
Back to top
Report?
bradwery Offline
#4 Posted : Monday, July 26, 2010 4:53:33 PM
Rank: Administration

Medals:

Groups: Administration
Joined: 2/5/2009
Posts: 84
Location: Manitoba, Canada

Thanks: 0 times
Was thanked: 3 time(s) in 3 post(s)
You may need to upgrade your version of Open Client. Are you running something older than version 12.5?

Also, what version of QweryBuilder are you running. Better message handling was added for ASE somewhere around 5.5.0.
Brad Wery
Lead Architect
Back to top
WWW BLOG
Report?
DavidGriffiths Offline
#5 Posted : Monday, July 26, 2010 4:58:12 PM
Rank: Member

Medals:

Groups: Member
Joined: 9/16/2009
Posts: 12
Location: Vancouver

Thanks: 1 times
Was thanked: 0 time(s) in 0 post(s)
We are running 12.5.1, I believe (according to SQL Advantage).

I am running QweryBuilder 6.0.2.

David
Back to top
Report?
bradwery Offline
#6 Posted : Monday, July 26, 2010 5:54:22 PM
Rank: Administration

Medals:

Groups: Administration
Joined: 2/5/2009
Posts: 84
Location: Manitoba, Canada

Thanks: 0 times
Was thanked: 3 time(s) in 3 post(s)
That could be the version of ASE that you're running. Can you look at your systems Environment Variables for an entry called: SYBASE_OCS

This should tell you the version of Open Client that you're running. Alternatively you can find the directory that has the libct.dll file:

E.g.

C:\sybase\OCS-15_0\dll


Brad Wery
Lead Architect
Back to top
WWW BLOG
Report?
DavidGriffiths Offline
#7 Posted : Tuesday, July 27, 2010 9:20:45 AM
Rank: Member

Medals:

Groups: Member
Joined: 9/16/2009
Posts: 12
Location: Vancouver

Thanks: 1 times
Was thanked: 0 time(s) in 0 post(s)


C:\sybase\OCS-12_5

I don't actually have Sybase installed locally - just the client.

David
Back to top
Report?
bradwery Offline
#8 Posted : Tuesday, July 27, 2010 4:10:52 PM
Rank: Administration

Medals:

Groups: Administration
Joined: 2/5/2009
Posts: 84
Location: Manitoba, Canada

Thanks: 0 times
Was thanked: 3 time(s) in 3 post(s)
We reproduced the problem. We will get a fix to you ASAP.

Thanks,
Brad Wery
Lead Architect
Back to top
WWW BLOG
Report?
DavidGriffiths Offline
#9 Posted : Tuesday, July 27, 2010 4:18:32 PM
Rank: Member

Medals:

Groups: Member
Joined: 9/16/2009
Posts: 12
Location: Vancouver

Thanks: 1 times
Was thanked: 0 time(s) in 0 post(s)
Very cool.

Thanks, Brad.

David.
Back to top
Report?
bradwery Offline
#10 Posted : Thursday, August 05, 2010 5:04:34 PM
Rank: Administration

Medals:

Groups: Administration
Joined: 2/5/2009
Posts: 84
Location: Manitoba, Canada

Thanks: 0 times
Was thanked: 3 time(s) in 3 post(s)
We identified the cause of the problem but unfortunately the fix is not very straightforward. It may take us a little bit of time to resolve this.

For now, to work around this, you can create a data source to the same ASE instance but check the Unicode checkbox in the data source registration window. This option has it's own limitations but it's a work around for now.

Brad Wery
Lead Architect
Back to top
WWW BLOG
Report?
bradwery Offline
#11 Posted : Friday, August 06, 2010 10:50:45 AM
Rank: Administration

Medals:

Groups: Administration
Joined: 2/5/2009
Posts: 84
Location: Manitoba, Canada

Thanks: 0 times
Was thanked: 3 time(s) in 3 post(s)
David,

I'm not sure if you're watching this thread or not. We found a solution and are currently testing it. Once we confirm that it solves the problem, we would like to get you an update. Can you please email us at Support@Werysoft.com.

Thanks
Brad Wery
Lead Architect
Back to top
WWW BLOG
Report?
bradwery Offline
#12 Posted : Friday, August 06, 2010 1:43:40 PM
Rank: Administration

Medals:

Groups: Administration
Joined: 2/5/2009
Posts: 84
Location: Manitoba, Canada

Thanks: 0 times
Was thanked: 3 time(s) in 3 post(s)
We did some testing and found that this fix only works of OC 15. Sorry about that. We're going to continue to look into this.
Brad Wery
Lead Architect
Back to top
WWW BLOG
Report?
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFVision Theme by Jaben Cargman (Tiny Gecko)
Powered by YAF 1.9.4 RC1 | YAF © 2003-2009, Yet Another Forum.NET
This page was generated in 0.521 seconds.
Copyright © 2008-2010 Werysoft Inc. All rights reserved.
SQL Query Tool | SQL Editor | Database Development Tool | SQL References | Testimonials