aspose file tools*
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
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