Re: Korean text going into DB as '??????

2011-10-19 Thread Paul Hastings
On 10/19/2011 12:11 PM, Mark Mandel wrote: Also, you may want to check the advanced datasource settings to see if there is a UTF-8 option that needs enabling. needed if you're using cfqueryparam (which you should) otherwise unicode hinting: INSERT someTable(SomeTxtColumn) VALUES

Re: Korean text going into DB as '??????

2011-10-19 Thread Paul Kukiel
Did you enable High ASCII checkbox on teh datasource in CFADMIN. On Oct 19, 2011, at 2:35 PM, Torrent Girl wrote: Hi All. I have been working with Korean content and am now displaying it my pages properly BUT when I add it to the DB (SQL 2008 - nvarchar), the Korean content is

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
On 10/19/2011 12:11 PM, Mark Mandel wrote: Also, you may want to check the advanced datasource settings to see if there is a UTF-8 option that needs enabling. needed if you're using cfqueryparam (which you should) otherwise unicode hinting: INSERT someTable(SomeTxtColumn) VALUES

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
Did you enable High ASCII checkbox on teh datasource in CFADMIN. On Oct 19, 2011, at 2:35 PM, Torrent Girl wrote: Hi All. I have been working with Korean content and am now displaying it my pages properly BUT when I add it to the DB (SQL 2008 - nvarchar), the Korean content

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
What's the code you are using to insert it? Also, you may want to check the advanced datasource settings to see if there is a UTF-8 option that needs enabling. Mark Here is the code: UPDATE citiContent SET koreanSiteSection =

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
Did you enable High ASCII checkbox on teh datasource in CFADMIN. On Oct 19, 2011, at 2:35 PM, Torrent Girl wrote: Hi All. I have been working with Korean content and am now displaying it my pages properly BUT when I add it to the DB (SQL 2008 - nvarchar), the Korean content

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
Did you enable High ASCII checkbox on teh datasource in CFADMIN. On Oct 19, 2011, at 2:35 PM, Torrent Girl wrote: Hi All. I have been working with Korean content and am now displaying it my pages properly BUT when I add it to the DB (SQL 2008 - nvarchar), the Korean content

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
Did you enable High ASCII checkbox on teh datasource in CFADMIN. On Oct 19, 2011, at 2:35 PM, Torrent Girl wrote: Hi All. I have been working with Korean content and am now displaying it my pages properly BUT when I add it to the DB (SQL 2008 - nvarchar), the Korean content

Re: Korean text going into DB as '??????

2011-10-19 Thread Russ Michaels
what happens if you query the database from Management studio, do you see the correct data ? this should at least tell you if the data is being saved properly or not. On Wed, Oct 19, 2011 at 1:54 PM, Torrent Girl moniqueb...@gmail.com wrote: Did you enable High ASCII checkbox on teh datasource

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
what happens if you query the database from Management studio, do you see the correct data ? this should at least tell you if the data is being saved properly or not. yes I get the correct data. I create a page using the code below: cffile action = write

Re: Korean text going into DB as '??????

2011-10-19 Thread Scott Stewart
It sounds like a font issue, use this link, (World Taekwondo Federation, Korean site) if it renders correctly than you have the Hangul font installed. If it doesn't then you'll need to install the Korean Language (Hangul) font..and this more than likely the root of the rendering issue.

Re: Korean text going into DB as '??????

2011-10-19 Thread Paul Hastings
On 10/19/2011 7:05 PM, Torrent Girl wrote: I tried the N' option with and without cfqueryparam and it didn't work. use one or other. good practice dictates using cfqueryparam, so make sure you've turned on unicode for that DSN in cfadmin. use unicode hinting if you can't or won't use

Re: Korean text going into DB as '??????

2011-10-19 Thread Paul Hastings
On 10/19/2011 9:08 PM, Scott Stewart wrote: It sounds like a font issue, in the interest of education, no this is NOT a font issue. using a font that doesn't contain the chars you're trying to display usually results in empty squares ([]) or a square w/that char's hex value. if the encoding

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
It sounds like a font issue, use this link, (World Taekwondo Federation, Korean site) if it renders correctly than you have the Hangul font installed. If it doesn't then you'll need to install the Korean Language (Hangul) font..and this more than likely the root of the rendering issue.

Re: Korean text going into DB as '??????

2011-10-19 Thread Scott Stewart
you'd need to install the font locally, unless I misread your post, it's saving correctly, just not displaying correctly. the font would need to be installed in order for the browser to use it to display the content. On Wed, Oct 19, 2011 at 1:51 PM, Torrent Girl moniqueb...@gmail.com wrote: It

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
you'd need to install the font locally, unless I misread your post, it's saving correctly, just not displaying correctly. the font would need to be installed in order for the browser to use it to display the content. When I open the file, that was saved using the same content that was entered

Re: Korean text going into DB as '??????

2011-10-19 Thread Scott Stewart
the question is, can you see the saved content with the font installed (in a browser) On Wed, Oct 19, 2011 at 2:18 PM, Torrent Girl moniqueb...@gmail.com wrote: you'd need to install the font locally, unless I misread your post, it's saving correctly, just not displaying correctly. the font

Re: Korean text going into DB as '??????

2011-10-19 Thread sslone
This maybe a long shot, but try inserting at the top of your page file: cfprocessingdirective pageencoding = EUC-KR/ cfcontent type=text/html; charset=EUC-KR and see if that makes a difference in the output... /S ~|

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
the question is, can you see the saved content with the font installed (in a browser) yes. I created the page first manually. I test it to make sure the page is correct THEN add the code to the database. After the code is entered, a cfm file is created.

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
This maybe a long shot, but try inserting at the top of your page file: cfprocessingdirective pageencoding = EUC-KR/ cfcontent type=text/html; charset=EUC-KR and see if that makes a difference in the output... /S I added it and get the following message: Cannot use the charset utf-8

Re: Korean text going into DB as '??????

2011-10-19 Thread Scott Stewart
So once the .cfm page is generated you run into the problem? On Wed, Oct 19, 2011 at 3:44 PM, Torrent Girl moniqueb...@gmail.com wrote: the question is, can you see the saved content with the font installed (in a browser) yes. I created the page first manually. I test it to make sure the

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
This maybe a long shot, but try inserting at the top of your page file: cfprocessingdirective pageencoding = EUC-KR/ cfcontent type=text/html; charset=EUC-KR and see if that makes a difference in the output... /S I think the problem is when it actually saves the page. What is I try

Re: Korean text going into DB as '??????

2011-10-19 Thread Scott Stewart
I think it's EUC-KR not EUC_KR Dash vs. underscore On Wed, Oct 19, 2011 at 3:47 PM, Torrent Girl moniqueb...@gmail.com wrote: This maybe a long shot, but try inserting at the top of your page file: cfprocessingdirective    pageencoding = EUC-KR/ cfcontent type=text/html; charset=EUC-KR and

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
This maybe a long shot, but try inserting at the top of your page file: I think the problem is when it actually saves the page. What is I try adding the N' to the code where it saves the cfm file? Here is how I got the file to save the page properly (YAY) I added charset=utf-8 to the

Re: Korean text going into DB as '??????

2011-10-19 Thread Scott Stewart
Nice!! Well done On Wed, Oct 19, 2011 at 4:33 PM, Torrent Girl moniqueb...@gmail.com wrote: This maybe a long shot, but try inserting at the top of your page file: I think the problem is when it actually saves the page. What is I try adding the N' to the code where it saves the cfm file?

Re: Korean text going into DB as '??????

2011-10-19 Thread Torrent Girl
Nice!! Well done Thanx :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Korean text going into DB as '??????

2011-10-18 Thread Torrent Girl
Hi All. I have been working with Korean content and am now displaying it my pages properly BUT when I add it to the DB (SQL 2008 - nvarchar), the Korean content is changed to . ANY suggestions? ~| Order the Adobe

Re: Korean text going into DB as '??????

2011-10-18 Thread Mark Mandel
What's the code you are using to insert it? Also, you may want to check the advanced datasource settings to see if there is a UTF-8 option that needs enabling. Mark On Wed, Oct 19, 2011 at 2:35 PM, Torrent Girl moniqueb...@gmail.com wrote: Hi All. I have been working with Korean content