Aleks
asked on
Imported characters from spreadsheet look strange on ASP page
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:
UPDATE dbo.Users
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.
Source: http://www.fileformat.info/info/charset/UTF-8/list.htm
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:
UPDATE dbo.Users
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.
Source: http://www.fileformat.info/info/charset/UTF-8/list.htm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
If we read the initial question you can see the character in the database is what the actual character should show on the webpage.
I already have a query to replace one. But I want to see if someone already has a query that includes all the characters in the link I included at the bottom. Otherwise I'll have to create it myself.
I already have a query to replace one. But I want to see if someone already has a query that includes all the characters in the link I included at the bottom. Otherwise I'll have to create it myself.
ASKER
I am spreading the points. my DB doesn't support non-Latin characters, so I am just removing the accents. thanks!
ASKER