Find out: what is the hexadecimal value?
SELECT HEX(your_column_name) FROM your_table_name; If you see 3F, then that really is the encoding for ?, so no wonder you see “?”. Probably this happened because of a problem converting a particular character from your client character set to the target character set. • Find out: is a literal round trip possible, that is, if you select “literal” (or “_introducer hexadecimal-value”) do you get “literal” as a result? For example, with the Japanese Katakana Letter Pe, which looks like ペ’, and which exists in all CJK character sets, and which has the code point value (hexadecimal coding) 0x30da, enter: SELECT ‘ペ’ AS `ペ`; /* or SELECT _ucs2 0x30da; */ If the result doesn’t look like ペ, a round trip failed. For bug reports, we might ask people to follow up with SELECT hex(‘ペ’);. Then we can see whether the client encoding is right. • Find out: is it the browser or application? Just use mysql (the MySQL client program, which on Windows will be mysql.exe). If mysql displays correctly but your
Related Questions
- How do I convert the Legato Networked inquiry string hexadecimal value giving the DLT tape drive firmware to a number that matches Breece Hills list of downloadable firmware on the ftp website?
- How do I get the color-picker on the FooDraw program to take a hexadecimal RGB value?
- Find out: what is the hexadecimal value?
