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.
Currently i receive some square using inet.openurl.
Then i need to store them into MsSQL or MySQL.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Is it UTF8 or UTF16?
More info:
http://dev.mysql.com/doc/refman/6.0/en/charset-unicode.html
ASKER
Will UTF16 only be available in MySQL 6 ?
Yes. MySQL 4.1 only supports UTF8 and UCS2.
ASKER
For example Bdgh+s become Badghis.