Chinese text not working in terminal

I'm trying to paste chinese text into terminal but I just get lots of numbers instead. if I quickly paste as soon as terminal loads the paste will work that once but not again? Its utf-8 unicode i'm using.

I dont think its the font as it works in textedit th开发者_Go百科e only place I get the problem is in terminal but I need to use it to make my sqlite database.

What would be the best thing to do?

Thanks

Load Terminal Inspector, and make sure the Character Set Encoding has to be set to Unicode (UTF-8) and check the Wide glyphs for Japanese/Chinese/etc setting.

The best thing to do would probably be to write the data into an SQL file and perform that with sqlite3 mydatabase.db < mychinesetextfile.sql.

It's not pretty, on the whole; but it'll work.