I am using mysql 4.0 server. But in the database I can not use special characters (i.e. latin characters, root sign etc.) or can not use superscript or subscript. In the front end I am using VB. When I am copying the text from Ms word and pasting it the character changes.
Presently I am using field type Varchar. Please help me in this matter.
You can escape problematic characters with \ so to have a % inserted into the database it would have to look like \% in the query. You can read more about it here. There is also a high probability that VB (I'm not familiar with VB) will have a function to escape strings for mysql (PHP does :))
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.