i've tried inserting text files with two-byte characters and formatted as both Unicode and UTF-8 into a mySQL dB, but the values don't show up in the table. checking the mySQL server variables through phpMyAdmin i see this for language settings:
character set: latin1
character sets: latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8
dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew
win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
i checked the mySQL documentation and found this but don't understand:
If your want to add support for a new character set that includes multi-byte characters, you need to use the
multi-byte character functions.
Right now the best documentation on this is the character sets that are already implemented.
Look at the euc_kr, gb2312, gbk, sjis, and ujis character sets for examples.
These are implemented in the ctype-'charset'.c' files in thestrings' directory.
You must specify the mbmaxlen_MYSET=N value in the special comment at the top of the source file.
N should be set to the size in bytes of the largest character in the set.
i can't locate a "strings" directory.
how would i add support for Kanji, or Japanese characters?
any advice or insights very appreciated 🙂
