Link to home
Start Free TrialLog in
Avatar of mammouth
mammouth

asked on

Inet.openurl arabic character into db

How can i grab arabic character from a UTF-8 pages into VB keeping the right character.
Currently i receive some square using inet.openurl.

Then i need to store them into MsSQL or MySQL.
ASKER CERTIFIED SOLUTION
Avatar of Dana Seaman
Dana Seaman
Flag of Brazil image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mammouth
mammouth

ASKER

It's work, but when i retrieve them from mssql or mysql (varchar) thet loose all their character.
For example Bdgh+s become Badghis.

21807736 works for 50% of the problem. When i retrive them from mysql varchar, it loose all special character. As in db it stored like that: Bdgh+s
Have you set CHARSET correctly in MySQL?
Is it UTF8 or UTF16?
More info:
http://dev.mysql.com/doc/refman/6.0/en/charset-unicode.html
Will UTF16 only be available in MySQL 6 ?
Yes. MySQL 4.1 only supports UTF8 and UCS2.