problem with Unicode

[mrdj1002]

Hi guys
Well there was always an unsolved problem for me in developing vb apps for about 2 years. And that’s using Unicode in my apps in order to develop Farsi (Farsi characters are the same as Arabic’s plus for extra characters) versions of them and also develop Farsi apps for my own county men.
I want the caption of different controls (like a label, form, frame or textbox.text) to appear in Farsi while run time. I’ve red many articles on Unicode. Just last night I read a long confusing and also interesting 36 page article on Unicode but it didn’t give me the final solution that is how to implement Unicode in the way I want. How can I declare that I want to use Farsi? And how can I use it in my app?
Can any anybody tell me the solution or just show me a resource so I can find what I want. Also a sample app can help me a lot. Doesn’t matter in what language. Can any body help?
Thanks alot

[CHAMPGARY]

Multilangual Interface is really Headache, I also develop a same for that just follow these things
I don't know what database you r using but still...
1. Use Microsoft forms 2.0 Labels It supports different languages
2. Try to load all caption of labels progrmatically from database
3. Open all your tables and assign arabic font

Regards

Gary

[mrdj1002]

thanks gary
but the main reason I want to use unicode is that I can run my app in the spesified language without any dependance to reasources installed on user's computer such az fonts,dbs &...
so again using a db on my sys is not what i want. what if my user doesn't have that db or font on his/her system?

[mrdj1002]

any idea??

[CHAMPGARY]

Originally posted by mrdj1002
I want to use unicode is that I can run my app in the spesified language without any dependance to reasources installed on user's computer such az fonts,dbs &...
so again using a db on my sys is not what i want. what if my user doesn't have that db or font on his/her system?

I think if the user's OS is an arabic OS then it shouldn't create problem, but if it is English OS then.............??????
I had gone through all these problems of Unicode, To solve this problem atlast I installed font on user's os ,What is your system 's output?? Can you explain it little bit??

Gary

[mrdj1002]

I have win2000 english ver. and i can view the web pages that r using unicode. I guess ur solution is suitable for showing Farsi text. but what about typing in farsi or arabic. i mean left to right typing. the propertiy doesn't work on my system

[mrdj1002]

Hi guys again
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.
thanks 4 gary you helped me alot

[CHAMPGARY]

Originally posted by mrdj1002
Hi guys again
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?

To store unicode string in database(mdb) just change your font , I mean open the table you r using and from tool bar go to format -> font and change font to that particular language font for e.g. for Japanese we use Ms Mincho font
I think this will definitely solve your both problems...

Gary

[mrdj1002]

thanks Roger
But as I mentioned before I am a little hesitate to use a spitial font. coz it may hurt my add dependency form the user's resourses.
now I can display and type Farsi, arabic, chinese in my app. and I'm also writing a module which I can do the job easily(I will send it to you as soon as I comlited it). and I do all these with the help of "MS Arial unicode" which is installed on every win98 and higher.
Now the only problemis that a unicode char is a 2byte one and the mdb string field type accepts only 1byte chars. In other words mdb string field is not a unicode supporter platform. thats why I'm thinking of using byte or mem field.

[mrdj1002]

oh sorry Gary I made mistake and called u Roger(my client that i was e-maiing the same time)