Words with Accents do not appear

[amrigo]

Hi

I just record text data in an access database and use asp to show them in the page

The words with accents do not appear instead a square appear and not the letter with accents
eg.: ç,á,ã,â etc...

how can i fix it ? there is a function i can apply to show the letters with accents ?

Thank´s in advance

[wspeeckaert]

You have to use a unicode character set- try utf8

[webdevil99]

If you copy from Microsoft Word then you will get the character display problems. Virtual Machines are also likely to cause this problem.

You need to copy text using UTF8 instead of unicode, otherwise unicode characters will not be shown correctly. Otherwise its down to a simple find a replace.

Characters which are troublesome include:

curvy single quotes '
curvy double quotes "
hyphens
bullets

[amrigo]

You have to use a unicode character set- try utf8
How do y set to utf8?

[amrigo]

Thank´s

i try editing the file and adding this html tag:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

i also try to save a file with the content in the utf-8 encoding, after i copy the content and save the record, but did not work

What can be done in this case ?

Thank´s in advance

[wspeeckaert]

You have the change the character coding in the mysql table that stores the data. Use PhpMyAdmin.