Table of contents

Column charset: latin1

Select charset
latin1 (utf8) utf8 greek binary (utf8)
Insert charset latin1 (utf8)
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
OK
'\xc3\x8e\xe2\x80\x98\xc3\x8e\xe2\x80\x99\xc3\x8e\xe2\x80\x9c\xc3\x8e\xe2\x80\x9d'
ERROR 1267
None
OK
'????????'
ERROR 1267
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
utf8
ERROR 1366
None
None
None
ERROR 1366
None
ERROR 1267
None
ERROR 1366
None
ERROR 1267
None
ERROR 1366
None
None
None
greek
ERROR 1366
None
None
None
ERROR 1366
None
ERROR 1267
None
ERROR 1366
None
ERROR 1267
None
ERROR 1366
None
None
None
binary (utf8)
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
OK
'\xc3\x8e\xe2\x80\x98\xc3\x8e\xe2\x80\x99\xc3\x8e\xe2\x80\x9c\xc3\x8e\xe2\x80\x9d'
ERROR 1267
None
OK
'????????'
ERROR 1267
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
Back to top

Column charset: utf8

Select charset
latin1 (utf8) utf8 greek binary (utf8)
Insert charset latin1 (utf8)
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
OK
'\xc3\x8e\xe2\x80\x98\xc3\x8e\xe2\x80\x99\xc3\x8e\xe2\x80\x9c\xc3\x8e\xe2\x80\x9d'
None
None
OK
'????????'
None
None
OK
'\xc3\x8e\xe2\x80\x98\xc3\x8e\xe2\x80\x99\xc3\x8e\xe2\x80\x9c\xc3\x8e\xe2\x80\x9d'
None
None
utf8
OK
'????'
None
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
OK
'\xc1\xc2\xc3\xc4'
'\xc1\xc2\xc3\xc4'
'\xc1\xc2\xc3\xc4'
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
greek
OK
'????'
None
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
OK
'\xc1\xc2\xc3\xc4'
'\xc1\xc2\xc3\xc4'
'\xc1\xc2\xc3\xc4'
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
binary (utf8)
OK
'????'
None
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
OK
'\xc1\xc2\xc3\xc4'
'\xc1\xc2\xc3\xc4'
'\xc1\xc2\xc3\xc4'
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
Back to top

Column charset: greek

Select charset
latin1 (utf8) utf8 greek binary (utf8)
Insert charset latin1 (utf8)
ERROR 1366
None
ERROR 1267
None
ERROR 1366
None
None
None
ERROR 1366
None
None
None
ERROR 1366
None
None
None
utf8
OK
'????'
ERROR 1267
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
OK
'\xc1\xc2\xc3\xc4'
'\xc1\xc2\xc3\xc4'
'\xc1\xc2\xc3\xc4'
OK
'\xc1\xc2\xc3\xc4'
None
None
greek
OK
'????'
ERROR 1267
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
OK
'\xc1\xc2\xc3\xc4'
'\xc1\xc2\xc3\xc4'
'\xc1\xc2\xc3\xc4'
OK
'\xc1\xc2\xc3\xc4'
None
None
binary (utf8)
OK
'????????'
ERROR 1267
None
OK
'\xce\x9e\xc2\x91\xce\x9e\xc2\x92\xce\x9e\xc2\x93\xce\x9e\xc2\x94'
None
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
Back to top

Column charset: binary

Select charset
latin1 (utf8) utf8 greek binary (utf8)
Insert charset latin1 (utf8)
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
utf8
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
greek
OK
'\xc1\xc2\xc3\xc4'
None
None
OK
'\xc1\xc2\xc3\xc4'
None
None
OK
'\xc1\xc2\xc3\xc4'
'\xc1\xc2\xc3\xc4'
None
OK
'\xc1\xc2\xc3\xc4'
None
None
binary (utf8)
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
None
OK
'\xce\x91\xce\x92\xce\x93\xce\x94'
'\xce\x91\xce\x92\xce\x93\xce\x94'
None
Back to top

Legend

Back to top