*
The moose likes JDBC and the fly likes Sybase text column insert Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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: 60741
    
  65

"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


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Sybase text column insert
 
Similar Threads
Insert/update TEXT field in SYBASE?
Using setDate(column,Date) to insert date in sybase database
Problem using a String containing large number of characters.
Inserting formatted Date into DB from java
Sybase text column insert with Hibernate