A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Sybase text column insert
Joined: Mar 22, 2006
Sep 13, 2006 20:55:00
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
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%
Author and ninkuma
Joined: Jan 10, 2002
Sep 13, 2006 21:40:00
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
adjust your display name
to match it.
In particular, your display name must be a first
a last name separated by a space character, and must not be obviously fictitious.
Asking smart questions
Books by Bear
It is sorta covered in the
JavaRanch Style Guide
subject: Sybase text column insert
Problem using a String containing large number of characters.
Insert/update TEXT field in SYBASE?
Using setDate(column,Date) to insert date in sybase database
Inserting formatted Date into DB from java
Sybase text column insert with Hibernate
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015