SQLite importing CSV with Japanese text

I created a table in OpenOffice spreadsheet, saved it as a CSV file. It had one column in English and the others in Japanese. I imported it into SQLite but no matter how I encode it (there are lots of options), for example UTF-8, 日本語　Windows, etc., when the table is imported the Japanese columns are all mixed up symbols and gibberish. At the point of madness I even went for ASCII encoding, but nothing worked.

I can manually input the fields and the Japanese shows up great. Bu开发者_如何学Got I would literally need to do this a thousand times by hand if I OPenOffice and SQLite don't play nice.

Please help.

As a dead-sure way you can convert it to HTML with PHPs Multibyte functions and transfer it as ASCII.