This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Exception in executing the query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Exception in executing the query" Watch "Exception in executing the query" New topic
Author

Exception in executing the query

Sanjeev Kaushik
Ranch Hand

Joined: Aug 01, 2002
Posts: 105
I am facing a problem in inserting the words with accentuation(Spanish language). For example column width is 9 and I am putting value Rodr�guez in thic column.
Though this value is of length 9, still I get "inserted too large value" exception for this.

Any suggestion would be highly appreciated.


Sanjeev Kaushik
Sanjeev Kaushik
Ranch Hand

Joined: Aug 01, 2002
Posts: 105
My DB is Oracle 9.2.0.4 and Charset is UTF-8
asirob civokviz
Greenhorn

Joined: Jun 12, 2004
Posts: 24
what is type of your column? If not nvarchar then
set it!! varchar stores each character as one byte
and nvarchar as two bytes (and I guess that is what
you need to store spanish letters).

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Exception in executing the query
 
Similar Threads
getting null pointer exception! how to fix it.
On SQL Error 407
'java.sql.SQLException: Out of range value for column' error
hibernate mapping xml
JTable Column Validation