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 ';
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 '\';