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
Web DevelopmentASPSQL
Last Comment
Aleks
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I assume that is a function that is added to the Database. The data is already in the database, how can I run a query that would encode those characters with accents, etc ?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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!