Re: Report builder charset?
bert db wrote: > I just found a solution, well sort of a hack. I found out that when I wrote > the "â¬" directly in a text field in the builder it prints okay (whichever > encoding I use (cp1252 or identity-H). I then isolated the value of the > character returned by the database for this sign ( 128 for the encoding iso > 8859-1, but for whatever reason it is 191 for the cp1252 (hex(80)= 191 ?? > ;-)) ) and transform all of these characters to the ⬠sign with a simple > replace. there's no euro char in the iso-8859-1 (latin-1) charset, it came out well before the existence of the euro. the euro is found in iso-8859-15 (AKA latin-9, don't ask) where it's at decimal 164 codepoint or in unicode at decimal 8364. hex 80 *is* decimal 128. decimal 191 (hex BF) is an inverted question mark ¿ in windows-1252 (ditto for unicode). i suggest you front-to-back review your data entry process & make sure the encodings are all the same for every part of your app. also make sure that the oracle charset is exactly the same the cf ones, especially as oracle likes to name it's own charsets the same as ISO/IEC ones even though they are slightly different. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report builder charset?
> bert db wrote: > > Well the oracle database uses the charset ISO 8859-1 which works > fine for all the coldfusion pages. > > unless you've changed the default encoding for cf from utf-8, it > shouldn't (for > some chars anyway). Well I have these directives in my entry point: > > > I have also looked at the Cp1252 and it should contain the ⬠sign > (Hex80). > > oops, you're right i was thinking of latin-1, cp1252 is a superset of > latin-1 > (apparently i forgot even though i keep reminding people of this fact > on an > almost daily basis ;-). > > > All of this tells me that there is something quite weird... > > what's the encoding on that page? are you using cfprocessingdirective? > is there > a public page that shows this problem that i can peek at? can i see > the code? > (send off-list). > I just found a solution, well sort of a hack. I found out that when I wrote the "â¬" directly in a text field in the builder it prints okay (whichever encoding I use (cp1252 or identity-H). I then isolated the value of the character returned by the database for this sign ( 128 for the encoding iso 8859-1, but for whatever reason it is 191 for the cp1252 (hex(80)= 191 ?? ;-)) ) and transform all of these characters to the ⬠sign with a simple replace. I would prefer to understand the underlying cause, but since i've started with coldfusion a year ago, I have learned not to ask too many questions and try to find hacks for whatever does not work correctly. Thanks a lot for you patience. B. PS. (If you want to have fun run this code you will be amazed by the result: #test# --- #test * 100# --- #(test * 100) MOD 100# --- #test# --- #test * 100# --- #(test * 100) MOD 100# --- #test# --- #test * 100# --- #(test * 100) MOD 100# --- #test# --- #test * 100# --- #(test * 100) MOD 100# --- #test# --- #test * 100# --- #(test * 100) MOD 100# --- ) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report builder charset?
bert db wrote: > Well the oracle database uses the charset ISO 8859-1 which works fine for all > the coldfusion pages. unless you've changed the default encoding for cf from utf-8, it shouldn't (for some chars anyway). > I have also looked at the Cp1252 and it should contain the ⬠sign (Hex80). oops, you're right i was thinking of latin-1, cp1252 is a superset of latin-1 (apparently i forgot even though i keep reminding people of this fact on an almost daily basis ;-). > All of this tells me that there is something quite weird... what's the encoding on that page? are you using cfprocessingdirective? is there a public page that shows this problem that i can peek at? can i see the code? (send off-list). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report builder charset?
> bert db wrote: > > > I tried this option, it did remove the '?' character, but > unfortunately it does not print anything. > > got the right font (ie one that supports those chars)? what's the > app's intended > encoding? Well the oracle database uses the charset ISO 8859-1 which works fine for all the coldfusion pages. I have tried changing the different fonts but no luck with that either. I have incorporated the query directly in the cfr, instead of the cfm, to see if there was a problem in the communication between the two but no luck either. I have also looked at the Cp1252 and it should contain the ⬠sign (Hex80). All of this tells me that there is something quite weird... I already had quite a number of "problems" with cfr. But this tops it all. B. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report builder charset?
bert db wrote: > I tried this option, it did remove the '?' character, but unfortunately it > does not print anything. got the right font (ie one that supports those chars)? what's the app's intended encoding? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report builder charset?
>bert db wrote: >> I have some report created with the report builder MX7. I am running into >> some problems with the charset it uses. Some of my users have put some exotic > >"exotic"? not to them i imagine. Probably not to them ;-) If only everybody used only ASCII chars our job would be a lot easier ;-) > >> caracters in text fields (principally the 'â¬' sign). I have no problems >> within my coldfusion pages but in the generated pdf, it prints out as a '?'. > >plain cf/html works ok? the cfr is called from a simple cf page where I define the query, and when in that page I do a simple cfoutput of the info it prints correctly. > >> I was wondering if anybody knows how to specify the charset that the builder >> should use, or if anybody knows the charset used by the report builder (there >> is always a way to change the charset returned by the DB). I have looked in >> the docs but could not find anything about this. > >press F8 to get the preferences dialog (for some strange reason it's under the >"edit" menu), the "PDF character encoding" value should be "Identity-H" not >windows codepage 1252 (cp-1252 which i think doesn't contain the euro). I tried this option, it did remove the '?' character, but unfortunately it does not print anything. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report builder charset?
bert db wrote: > I have some report created with the report builder MX7. I am running into > some problems with the charset it uses. Some of my users have put some exotic "exotic"? not to them i imagine. > caracters in text fields (principally the 'â¬' sign). I have no problems > within my coldfusion pages but in the generated pdf, it prints out as a '?'. plain cf/html works ok? > I was wondering if anybody knows how to specify the charset that the builder > should use, or if anybody knows the charset used by the report builder (there > is always a way to change the charset returned by the DB). I have looked in > the docs but could not find anything about this. press F8 to get the preferences dialog (for some strange reason it's under the "edit" menu), the "PDF character encoding" value should be "Identity-H" not windows codepage 1252 (cp-1252 which i think doesn't contain the euro). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313838 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Report builder charset?
Hi, I have some report created with the report builder MX7. I am running into some problems with the charset it uses. Some of my users have put some exotic caracters in text fields (principally the 'â¬' sign). I have no problems within my coldfusion pages but in the generated pdf, it prints out as a '?'. I was wondering if anybody knows how to specify the charset that the builder should use, or if anybody knows the charset used by the report builder (there is always a way to change the charset returned by the DB). I have looked in the docs but could not find anything about this. Thanks, B. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
