Hi all

I have Sybase 12.5 with jConnect4.5.

I have a table with a varchar column. When I insert data of more than
255 bytes with the JConnect4.5's jdbc driver there's no problem. If I
try to get the data of this column, the same jdbc driver cuts the data
after 255 bytes.

Does anybody know why?

Simon

Hi all again

I mayby found a reason for that problem. It seems to be that I have
especially write that code:
SybDriver drv =
(SybDriver)Class.forName("com.sybase.jdbc2.jdbc.Sy bDriver").newInstance();
drv.setVersion(drv.VERSION_LATEST);
DriverManager.registerDriver(drv);

which is no jdbc standard.

Does Sybase provide's a patch for that problem, so that the jdbc
standard is supported?

Simon

Simon Bieri schrieb:

> Hi all
>
> I have Sybase 12.5 with jConnect4.5.
>
> I have a table with a varchar column. When I insert data of more than
> 255 bytes with the JConnect4.5's jdbc driver there's no problem. If I
> try to get the data of this column, the same jdbc driver cuts the data
> after 255 bytes.
>
> Does anybody know why?
>
> Simon
>

--
I believe the entire IQ of mankind is a constant
while the count of human being is constantly increasing.
(As you can see in the governments of the world)

-!Please only use the Reply-to address!-

On Thu, 06 Nov 2003 11:28:34 +0100, Simon Bieri wrote:

> Hi all
>
> I have Sybase 12.5 with jConnect4.5.
>
> I have a table with a varchar column. When I insert data of more than
> 255 bytes with the JConnect4.5's jdbc driver there's no problem. If I
> try to get the data of this column, the same jdbc driver cuts the data
> after 255 bytes.

I'm pretty sure that you need jConnect 5.x to handle wide varchars, and
you may need to configure it (at run-time) to allow wide varchars. I'd go
check the jConnect 5.x documentation for details.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler@peppler.org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html