Kanji - UTF-8 encoding from MySQL database
in
Contributed Library Questions
•
2 years ago
Hello everyone,
I'm working on a sketch which displays kanji (Japanese characters). If I load these from an (UTF-8 encoded) txt-file I have no problems viewing them in Processing. The problem is that I have added them to an mysql database (also UTF-8 encoded), and when I load them from the database I can't view them correctly in Processing.
If I use the same database with PHP it'll work. I use the SQLibrary btw. I already tried stuff like this:
String database = "kanji?characterEncoding=UTF-8";
I guess the problem has something to do with the encoding withing my MySQL-Database, so maybe it's not really a Processing related question at all. But I'm sure there are alot of people who know more about text-encoding than I do!
Oh, btw, Kind of related. I also have a file where all the kanji are in JISX0208. I've tried everything but i can't even VIEW the file, let alone load it into Processing. Any ideas on that?
Thanks in advance!
I'm working on a sketch which displays kanji (Japanese characters). If I load these from an (UTF-8 encoded) txt-file I have no problems viewing them in Processing. The problem is that I have added them to an mysql database (also UTF-8 encoded), and when I load them from the database I can't view them correctly in Processing.
If I use the same database with PHP it'll work. I use the SQLibrary btw. I already tried stuff like this:
String database = "kanji?characterEncoding=UTF-8";
I guess the problem has something to do with the encoding withing my MySQL-Database, so maybe it's not really a Processing related question at all. But I'm sure there are alot of people who know more about text-encoding than I do!
Oh, btw, Kind of related. I also have a file where all the kanji are in JISX0208. I've tried everything but i can't even VIEW the file, let alone load it into Processing. Any ideas on that?
Thanks in advance!
1
