#1 - July 25, 2011, 7:02 p.m.
I am using the API (obviously) to pull the guild member list. Some of our guild members have the ALT code characters in their names. With SQL databases, it does not know what to do with them (at least with a standard INSERT query), so it puts very interesting characters in the database instead.
How do you work around this so as to have the proper ALT character go into the database as is?
Please note that the initial pull from the API to my object setup is just fine as far as the name markup is concerned. The only trouble area is the insert into the database.
Here is what I am dealing with: http://www.girthguild.com/wow-roster.php (Go down to Applicants and you will see a couple of problems).
Thanks.
----------------------
Had a thought. Would a good way to do this be to url-encode the character name on the database insert and just decode it on the data pull?
