drop user failed 6706 the string contains an untranslatable character

Aster
Highlighted
New Member

drop user failed 6706 the string contains an untranslatable character

Hello!

I am new to teradata and I have an error when I want to delete a user that was created with invalid characters.
I do not identify the how to erase it already tried the mannered ways but sends the same error.T
he user comes out with a weird character and spaces.I hope and you can give me your support and advice.

ERROR: drop user failed 6706 the string contains an untranslatable character

DROP USER "MB62021 ";
DROP USER 'MB62021 ';
USER.PNG
Greetings.
1 REPLY 1
Teradata Employee

Re: drop user failed 6706 the string contains an untranslatable character

Obtain the hex representation of the name and use a Unicode name literal.

SELECT CHAR2HEXINT(UserName) FROM DBC.UsersV WHERE UserName like '%MB62021%'; 

Let's say the value is 004D0042003600320030003200311234

Add a U&" at the front, add a \ before each group of four digits, and add " UESCAPE '\' at the end. So your DROP statement would look like

DROP USER U&"\004D\0042\0036\0032\0030\0032\0031\1234" UESCAPE '\';