|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It痴 your move---enter to win here! |
|
#1
June 30th, 2004, 10:41 AM
|
|||
|
|||
|
Internation characters from MX6.1/MS SQL 2000/MS Server 2003
Hi.
We have just upgraded from CF 5 to CF MX6.1. We have japanese characters inserted in the code of our .cfm page. We also have the same characters being called from our MS SQL 2000 database through a ODBC socket connection, and placed in the same page. At this point we know how to display one or the other, but not both at the same time. The inclusion of charset=x-sjis in the cfcontent tag allows us to see the coded Japanese content properly. The exclusion of chaset=x-sjis from the cfcontent tag allows us to see only the Japanese characters pulled from the database properly. Success in one prevents the other from displaying properly. Has anyone been able to get both to display at the same time? Also the ODBC sockets that we are using seem to have stopped working and have been crashing the server. Using the CF MX6.1 MS SQL database connection type seems to prevent any success at all with the displaying of foreign database characters. I am really getting close to reinstalling Coldfusion v.5. ------------------------first code displays the coded Japanese characters properly-------------------------------- <cfprocessingDirective pageencoding="x-sjis"> <cfset setEncoding("url","x-sjis")> <cfset setEncoding("form","x-sjis")> <cfcontent type="text/html; charset=x-sjis"> <cfquery name="ArticleQry" datasource="xxxxx" username="xxxxxt" password="xxxxx"> Select * from articletext </cfquery> <cfoutput> #ArticleQry.textvalue# </cfoutput> <P>高等教育を目指す学生が最適な学校を見つけたいと願うように、大学側も入学 ｶがそれぞれの「キャンパス文化」に相応し*、学校の方針および ﾚ標を共有できるかを確かめたがっています。教育は学生と同様に学校にとっても高 ｿな投資で*り、殆どの大学は定員を上回る入学願書を受け取ります。 <BR> ----------------------second code displays the database Japanese characters properly------------------------------ <cfprocessingDirective pageencoding="x-sjis"> <cfset setEncoding("url","x-sjis")> <cfset setEncoding("form","x-sjis")> <cfcontent type="text/html;"> <cfquery name="ArticleQry" datasource="xxxxx" username="xxxxxt" password="xxxxx"> Select * from articletext </cfquery> <cfoutput> #ArticleQry.textvalue# </cfoutput> <P>高等教育を-ﾚ指す学生が最適な学校を見つけたいと願うように、大学側も入学 ｶがそれぞれの「キャンパス文化」に相応し*、学校の方針および- ﾚ標を共-Lできるかを確かめたがっています。教育は学生と同-lに学校にとっても高 ｿな投資で り、-wどの大学は定員を上回る入学願書を受け取ります。 <BR>
|
|
#2
June 30th, 2004, 11:50 AM
|
|||
|
|||
|
I have never needed to use unicode in my apps, but I am sure this is possible. A Google search found these references, maybe they can help?
http://www.macromedia.com/support/c...alization_cfmx/ http://www.macromedia.com/support/c...nts/tn18331.htm http://livedocs.macromedia.com/cold...n.htm#wp1141005
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums Last edited by kiteless : June 30th, 2004 at 11:54 AM.
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > Internation characters from MX6.1/MS SQL 2000/MS Server 2003 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
