ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Rene Vervik <thomas.ver...@gmail.com>
Subject Reading from database using iBatis
Date Sun, 19 Oct 2008 17:45:21 GMT

Hello

I am trying to insert the following statement using iBatis:

insert into 
		ARTICLE_EXTENDED_TEXT
	(
		AET_ART_ID, AET_HEADING_TEXT, AET_PRODUCT_DESC_TEXT, AET_PRODUCT_DESC_URL
    	)values( 
		#artID#, #artHeadingText#, #artProductDescText#, #artProductDescURL#
	)

The clue here is #artProductDescText#, which is the text bellow (in
norwegian). I get an data truncation exception when inserting this in the
database. I know that truncation error normaly means that the data is too
long, so I would like to stress that this is not the case here. The column
is "AET_PRODUCT_DESC_TEXT" and has mysql type "text". The problem is
encoding, cause if I remove the norwegian letters (æøå) and replace them
with english letters, it works. 

So my question is: how do I specify the encoding when inserting to the
database (or reading from the database for that sake as well) using iBatis?



"Ajungilak presenterer her en svært bra vinterpose i 
høykvalitets europeisk gåsedun.  
Prisgunstig, lett i vekt, lite pakkvolum og ekstra 
komfort. Den har dobbeltlags fotboks for ekstra 
varme, samt ekstra polstring i hetten for å beskytte 
hodet fra kulden. 

Vekt: 1500 gr ekskl. trekk (180 cm)
Komfortgrense: -16 grader (EN 13537)"


in advance, thanks for all help :-)
br 
Thomas Vervik

-- 
View this message in context: http://www.nabble.com/Reading-from-database-using-iBatis-tp20058443p20058443.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message