I think a lot of Unicode characters got messed up in the conversion.
(2008-06-09, 06:02 AM)MrDoom Wrote: [ -> ]I think a lot of Unicode characters got messed up in the conversion.
Yeah, I noticed the conversion
It wasn't to do with the conversion, just a simple mix up of the wrong character sets being set
I have a field that has some non english characters in some of the records, eg:
V�stervik
Café
StraÌ°åÄe
Månzfa
Sérgio
ZÌ’rich
Fürstenfeld
What I need to do is if the record has a non-english character in it to do a calculation that finds all those records, so I can manually replace the non english "é", with "e".
My original idea was to make a list of all the non english characters and do a pattern match but there are too many non english characters and no real way to know them all.
Does anyone know how to do a pattern match or some other way to find all the non english character in this field? Thanks for your help
Do you any one have idea how can we type these characters?
please tell me