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

Images stored in a database...

2011-10-19 Thread JD Yeiter
Can anyone shed some light on this issue for me? I was originally storing some images in a database, but then I convinced myself that it wasn't the most efficient way to deliver the images, so I switched my solution to static files. In general, can someone walk me through the pros and cons of

Re: Images stored in a database...

2011-10-19 Thread Dominic Watson
Re caching in the browser, it will depend on both the browser and the http headers that are set in the getImage.cfm request. If you go down the CF serving the images route, ensure that you set appropriate expires headers using cfheader. Personally, I'd avoid using CF to serve the files. Your

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: Images stored in a database...

2011-10-19 Thread Russ Michaels
keep everything within the database, so it is good for portability, backup etc. However you are putting unnecessary load on the database as it will have to transfer quite big chunks of data back to the web server. The browser will cache all images on a page, however dynamic URL's such as those

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: Images stored in a database...

2011-10-19 Thread Claude Schnéegans
but then I convinced myself that it wasn't the most efficient way to deliver the images, so I switched my solution to static files. And you are right. The purpose of a database is to store data in some structured way to make possible sorting and searching. If you have nothing to sort or

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.

cgi.HTTP_USER_AGENT

2011-10-19 Thread Robert Harrison
I have an issue where user agent (cgi.HTTP_USER_AGENT) for IE 9 is being reported correctly on one server and incorrectly on another... http://www.vaughn.edu/test_useragent.cfm Reporting IE 9 correctly on CF8 server http://www.austin-williams.com/test_useragent.cfm

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: cgi.HTTP_USER_AGENT

2011-10-19 Thread Alan Rother
Comes up the same on each for me. IE9.0.8112.16421 - Windows 7 Pro 64 bit http://www.austin-williams.com/test_useragent.cfm Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; MALC) http://www.vaughn.edu/test_useragent.cfm Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1;

Re: cgi.HTTP_USER_AGENT

2011-10-19 Thread Carl Von Stetten
Is it possible that you set IE9 on your computer to use Compatibility View to simulate IE7 for that website? On 10/19/2011 11:05 AM, Robert Harrison wrote: I have an issue where user agent (cgi.HTTP_USER_AGENT) for IE 9 is being reported correctly on one server and incorrectly on another...

Re: cgi.HTTP_USER_AGENT

2011-10-19 Thread Carl Von Stetten
In fact, I just tested that very think on my machine and it did report back as IE7 instead of IE9. Carl On 10/19/2011 11:14 AM, Carl Von Stetten wrote: Is it possible that you set IE9 on your computer to use Compatibility View to simulate IE7 for that website? On 10/19/2011 11:05 AM, Robert

RE: cgi.HTTP_USER_AGENT

2011-10-19 Thread Robert Harrison
Even stranger now... https://portal.vaughn.edu/test_useragent.cfm this is reporting IE9 incorrectly. http://www.austin-williams.com/test_useragent.cfm this is reporting IE9 correctly. These site are on the same CF9 server. The only difference I can think of now would be some setting we

Re: cgi.HTTP_USER_AGENT

2011-10-19 Thread Carl Von Stetten
Sorry, thing instead of think. I'm typing with one arm in a sling.. :-[ . Carl On 10/19/2011 11:15 AM, Carl Von Stetten wrote: In fact, I just tested that very think on my machine and it did report back as IE7 instead of IE9. Carl On 10/19/2011 11:14 AM, Carl Von Stetten wrote: Is it

Re: cgi.HTTP_USER_AGENT

2011-10-19 Thread Alan Rother
It's not IIS or CF Your browser is what is sending that data - it's part of the HTTP request packet the browser sends when it requests a file. On Wed, Oct 19, 2011 at 11:16 AM, Robert Harrison rob...@austin-williams.com wrote: Even stranger now...

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: cgi.HTTP_USER_AGENT

2011-10-19 Thread Robert Harrison
Your browser is what is sending that data - it's part of the HTTP request packet the browser sends when it requests a file. Same browser from same machine reporting differently on different environments. Exact same CF file generating the output. There is something more going on here.

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: cgi.HTTP_USER_AGENT

2011-10-19 Thread Carl Von Stetten
Robert, I hate to add another response to the thread, but did you check whether you inadvertently enabled Compatibility View in IE9 when viewing the site that is reporting incorrectly? I was able to reproduce your results when this was turned on. Carl On 10/19/2011 11:24 AM, Robert

RE: Why cfajaximport tags=cfwindow works in CF 8 , but not CF 9

2011-10-19 Thread Nathan Chen
Yes, Dave, that's exactly what happened after I worked with my server folks on this issue. What happened was that the site is being hosted in a third party hosting company. Our server hits their server(some kind of proxy) but that server doesn't have \cfide\ folder. I changed my around and even

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: cgi.HTTP_USER_AGENT

2011-10-19 Thread Robert Harrison
I added the meta tags: meta http-equiv=X-UA-Compatible content=IE=9/ and it's still reporting back as IE7 in the https://portal.vaughn.edu/test_useragent.cfm environment. That code should have forced it to IE9 standards. What the heck! Robert B. Harrison Director of Interactive

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: cgi.HTTP_USER_AGENT

2011-10-19 Thread Dave Watts
Your browser is what is sending that data - it's part of the HTTP request packet the browser sends when it requests a file. Same browser from same machine reporting differently on different environments.  Exact same CF file generating the output. There is something more going on here.

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: Why cfajaximport tags=cfwindow works in CF 8 , but not CF 9

2011-10-19 Thread Dave Watts
Yes, Dave, that's exactly what happened after I worked with my server folks on this issue. What happened was that the site is being hosted in a third party hosting company. Our server hits their server(some kind of proxy) but that server doesn't have \cfide\ folder. I changed my around and

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: Images stored in a database...

2011-10-19 Thread Al Musella, DPM
You may get to a point where there is so much traffic in the SQL server that the rest of the website slows down or stops responding. I would use a cdn or set up a separate server to serve the static images. Note that google recommends using a different domain name for images (like

Re: Images stored in a database...

2011-10-19 Thread Pete Freitag
Another solution to consider for this besides a third party CDN is installing mod_xsendfile (you can get this for both Apache and IIS 7 via Helicon Ape). With mod_xsendfile on your server you simply write a X-Sendfile: c:\path\to\file.jpg in your getImage.cfm file (you don't need to serve it with

Re: Images stored in a database...

2011-10-19 Thread Gerald Guido
Awesome find Pete. Thanx for Sharing! G! On Wed, Oct 19, 2011 at 10:34 PM, Pete Freitag p...@foundeo.com wrote: Another solution to consider for this besides a third party CDN is installing mod_xsendfile (you can get this for both Apache and IIS 7 via Helicon Ape). With mod_xsendfile on

cfcontent parent page issues

2011-10-19 Thread Dawn Sekel
Has anyone come across this issue (IE8-same behavior in XP and Windows 7): - index.cfm page displays a table from a cfquery. The query is based on cfselect list allowing multiple entries in a cfform. Clicking submit on the form, correctly displays the table output below the form based on the

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: