I'm working on a learning language app, so far, that teaches
Thai to English speakers and English to Thai speakers. I'm pulling
lesson words from an access database that is storing foreign
characters just fine. Here is the xml page for the first lesson of
eng/thai -
http://www.netspeaknow.com/getlessonwords1.cfm
and code:
<cfquery name="getLastLessonID" datasource="langDB">
SELECT lastLessonID
FROM Users
WHERE userID = 1
</cfquery>
<cfif #getLastLessonID.RecordCount# EQ 1>
<cfquery name="getLessonWords" datasource="langDB">
SELECT LessonMP3.filePath, LessonWords.displayWord,
LessonWords.phonetic, LessonWords.definition
FROM LessonWords INNER JOIN LessonMP3 ON LessonWords.sndID =
LessonMP3.sndID
where lessonPlanID = 18
</cfquery>
</cfif>
<cfcontent type="text/xml" reset="yes">
<cfsetting showdebugoutput="No"
enablecfoutputonly="Yes">
<?xml version="1.0" encoding="UTF-8"?>
<cfoutput>
<results_packet>
<cfloop query="getLessonWords">
<rec displayword="#displayWord# - #phonetic#
/#definition#" sndurl="#filePath#" />
</cfloop>
</results_packet>
</cfoutput>
Here's the error I'm get trying create the same document with
Thai characters.
http://www.netspeaknow.com/getlessonwords2.cfm
I don't have any problem displaying foreign characters in my
browser:
Here's a page that is pulling the same data for the same
thai/eng lesson.
http://www.netspeaknow.com/lessonview_thai.cfm
Does anyone know how I can get foreign characters, not just
Thai, into my XML document?