For those of you on CF-Talk, apologies for the cross-post, but it's got sod-all takers
over there so I'll run it past yews lot (that is your actual Scouse).
================================
If you're using CFMX Standard and Oracle 9i, is it possible to save and
retrieve Unicode?
Every post relating to this suggests checking the "String Format" box in
the DSN page, which doesn't appear on the CFMX Standard DSN page.
I've successfully saved and retrieved Japanese characters to MySQL by
adding
useUnicode=true&characterEncoding=UTF-8
in the connection string, but can something along those lines be done
with either an ODBC or JDBC connection to Oracle. Or are we going to
have to stump up for Enterprise?
================================
As a follow up to that last comment, we've just installed CFMX 6.1 on a machine in
Developer-mode so we can see whether the native Oracle drivers are any different, and
even with the "String Format" box checked, the following SQL (the template is saved as
UTF-8 c/w BOM and happily displays the Japanese in DWMX and IE) doesn't successfully
insert Japanese characters into an NCLOB field.
<cfquery datasource="...">
insert into test (
ntest)
values (
<cfqueryparam cfsqltype="cf_sql_clob"
value="ここにデータを入力して">)
</cfquery>
<cfquery name="q" datasource="...">
select *
from test
</cfquery>
<cfdump var="#q#">
Thanks for any help or pointers.
--
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
