aspose file tools
The moose likes JDBC and the fly likes Sybase text column insert Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Sybase text column insert " Watch "Sybase text column insert " New topic
Author

Sybase text column insert

Balaji VR
Ranch Hand

Joined: Mar 22, 2006
Posts: 76
Hi,

I have a Sybase table that has a column of type TEXT.

What I am doing is that, I am reading characters from a file, convert them into String object and then insert into this column.
The value of the String gets into the TEXT column.

The String object (roughly 4K characters) gets inserted successfully into the column and when I do a select, i could see the characters correctly stored in the table's column.

But, when I try to insert a very big String(12MB file read), it gets stored as ??? into the table's column.

Please help me.


Bala<br />SCJP 1.4 98%<br />SCBCD 1.3 -- 88%
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 56224
    
  13

"Balaji VR",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
JavaRanch Sheriff


[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Sybase text column insert
 
Similar Threads
Sybase text column insert with Hibernate
Inserting formatted Date into DB from java
Using setDate(column,Date) to insert date in sybase database
Problem using a String containing large number of characters.
Insert/update TEXT field in SYBASE?