Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exception in executing the query

 
Sanjeev Kaushik
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My DB is Oracle 9.2.0.4 and Charset is UTF-8
 
asirob civokviz
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic