Chinese characters look great - I can read and write some Chinese (hell, I can SPEAK nearly fluently), but I probably wont' get any of them tattooed on me - I DO have Enochian tattoed on me, which is Angelic script - looks badass.
But the thing is, overall, just text makes for a pretty boring tattoo, I have text in combination with dragons on my forearms. I'd reccomend deciding on a symbol for Nicholas - something that you feel embodies him the best - his power animal, perhaps, or his moon sign. Find a way to relate that symbol of the embodiment of his personality to one that relates to your own, and plan a comprehensive piece that speaks to both.
Example: A bear and its cubs, A whale and a dolphin, a stag and the moon, a dragon and a wyrmling, etc etc.
In the end, writing is only a symbol - take that idea, and make it more abstract, in the end, it'll probably be more meaningful, and more beautiful than simple text alone.