distal-attribute
distal-attribute
distal-attribute
distal-attribute

strange font in query resultset

User, date Message
Written by BubikolRamios
2 years ago
Category: General
326 posts since Thu, 14 Jan 10
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
Written by BubikolRamios
2 years ago
326 posts since Thu, 14 Jan 10
http://shrani.si/f/u/hP/4Qg2YNHH/tmp.jpg
Written by ansgar
2 years ago
4801 posts since Fri, 07 Apr 06
Looks like an A to me, in a non-antialiased font. Copy to clipboard and paste somewhere else to see if it's A ?
Written by BubikolRamios
2 years ago
326 posts since Thu, 14 Jan 10
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
Written by ansgar
2 years ago
4801 posts since Fri, 07 Apr 06
Ok, then how was that value inserted?
Written by BubikolRamios
2 years ago
326 posts since Thu, 14 Jan 10
via csv.
Written by ansgar
2 years ago
4801 posts since Fri, 07 Apr 06
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.