Oracle 9i database via CFMX. It was my understanding that the
NLS_DATABASE_PARAMETERS.NLS_NCHAR_CHARACTERSET in Oracle needs to be
set to UTF8 and the NLS_DATABASE_PARAMETERS.NLS_CHARACTERSET can
remain at its default of WE8ISO8859P1 and this is how ours is setup.
>From the CFMX side I have tried having the check box for non-Latin
characters checked and not checked, it does not seem to make a
difference. I have a simple input page, just a form with text input
and a submit button, I have tried having this page with its META
CHARSET set to UTF-8 and no line at all but still get the same results
when I insert.
To test insert this, I have a Word document and I simply am copying
and pasting from it. When I past it in the text box it does appear to
retain its characters correctly though I do not read a lick of chinese
so no idea if it truely is.
The test code for what it is worth:
<form action="" method="post">
<input type="text" name="myText"><br /><input type="Submit">
</form>
And:
<cfquery name="insert" datasource="TestDSN">
INSERT INTO ACHINESETEST
(CHINESETEXT)
VALUES
(<cfqueryparam value="#Form.myText#" cfsqltype="cf_sql_varchar">)</cfquery>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
