Unicode & Database

[mrdj1002]

Hi guys
I was working on Unicode for a while and finally I learned how to use it in order to show Chinese, Arabic, and Indian etc. I show them on “MS forms 2.00” which is consisted of controls that support Unicode. Now I can display and type any language in them. BUT a few problems:
1.How can I store a Unicode string in to a database (a mdb for example)?
2. how can I restore Unicode strings form a db?
As an Unicode character is a 2 byte one and a simple ASCII char is 1 byte. a database string field refuses to accept my Unicode string.
Any suggestions? I’m thinking of using the binary field type but it is limited and also I think it will work very slowly besides I’ll have to say goodbye to SQL queries.

[mrdj1002]

any idea???