I imported data from a spreadsheet into an sql db table.
Some of the values have accents, etc. but on the ASP which uses UTF-8 encoding the accent shows with strange characters
This is an example.
table name: users
field : MiddleNm
Database value: Cléa
How it shows on the ASP webpage: ClÃ©a
I was able to run a query to replace the above accent with:
Set MiddleNm = replace(MiddleNm, 'é', 'é')
The problem is that there may be other characters that need to be replaced, I was wondering if there may be a query out there that replaces all the accents and other strange characters with the UTF-8 unicode.