user id translation table

I need to know any and all information about translation tables, the extent of their functionality and how to create one. I'm trying to solve the problem of charicter limitation across several platforms and am trying to create some sort of translation so that my users can have one UserID.

thanks all,

rod