Hi

I am trying to insert some data to my database and I am getting a right truncation error - so i turned of the error checking for the erros . The data has many international characters in it.

I now get a primary key exists because the data is truncated

This is what i am doing

ls_name=dw_1.getitemstring(ll_loop,"name")

// then selecting the database to see if it exists

select ...... where "name"=:ls_name

// i get the the result - not found on database

so it insert

insert....name=:ls_name

// i get an error saying the record already exists 

So  

Is there a way of checking what the database will truncate the data to and then truncate it in powerscript ?

thanks

Anderw