strange font in query resultset

632 posts
BubikolRamios's profile image BubikolRamios posted 12 years ago in General Permalink
see how first line is crunched:
http://shrani.si/f/u/hP/4Qg2YNHH/tmp.jpg

The field there is UTF8, The A at begining is not A at all.

Agalenatea redii--> HEX:
EFBBBF4167616C656E61746561207265
646969
632 posts
BubikolRamios's profile image BubikolRamios posted 12 years ago Permalink
http://shrani.si/f/u/hP/4Qg2YNHH/tmp.jpg
10136 posts
ansgar's profile image ansgar posted 12 years ago Permalink
Looks like an A to me, in a non-antialiased font. Copy to clipboard and paste somewhere else to see if it's A ?
632 posts
BubikolRamios's profile image BubikolRamios posted 12 years ago Permalink
It shows as A (pasted), but when backspace deleted there apperars a dot (not normal one ofcourse)

Also if I go select .. where like 'A%', it does not find it.
So 100% sure not A
10136 posts
ansgar's profile image ansgar posted 12 years ago Permalink
Ok, then how was that value inserted?
632 posts
BubikolRamios's profile image BubikolRamios posted 12 years ago Permalink
via csv.
10136 posts
ansgar's profile image ansgar posted 12 years ago Permalink
Well, then the CSV data or the import was done using some wrong charset, probably. Or the CSV data itself had the wrong character.

Please login to leave a reply, or register at first.