"The string contains an untranslatable character"

General
Enthusiast

"The string contains an untranslatable character"

Hi all,

I am trying to combine multiple rows into a single row,and in the process I created a global temporary table info_v. But Im getting error in this part:

insert into info_v select rank() over(partition by c_id order by translate_chk(person_name using  latin_to_unicode)),c_id,translate(person_name using latin_to_unicode) from tablename;

I get the error  *** Failure 6706 The string contains an untranslatable character.

                Statement# 1, Info =0 

despite using translate_chk function. Pls help!

Thanks in advance!

-Anju

1 REPLY

Re: "The string contains an untranslatable character"

Hi,

If other user is skewing his query using uneven rows to join on will this make my query run low even when he is in a lower priority amount of cpu assigned to his query?

Thanks,

NewTdat