Non Ascii Characters

[eddierosenthal]

This question is more about mysql than about sqlyog – so perhaps not the right forum.

i have some columns that have bad data, such as non ascii characters.

CaroleÊBelcher is an example ( see the characters embedded in this name for example).

they appear on a select statement as question marks.

If i export as html the non ascii characters show up, so somehow within sqlyog it is able to

see these characters as they are in a raw state – but why do they show up in the sql output as question marks?

I am trying to find a select statement that finds these characters, and is able to replace them.

Perhaps this is not possible in a non programmatic way, and is not possible thru sql alone.

Sure there are ways to do this outside of sql, and perhaps that is what i shall do.

thanks

eddie

[peterlaursen]

This is probably a dowuble encoding problem.

Please refer: http://www.webyog.com/faq/content/34/152/en/my-special-characters-display-as-_noisy_-latin-characters-in-sqlyog.html

[Author]

Posts