Is connection property oracle.jdbc.defaultNChar supported with supplied
Oracle driver in ColdFusion 8?
It seems to be impossible to save unicode encoded strings in nvarchar2 and
nchar table fields when
database charset (NLS_CHARACTERSET ) is not UTF8 or AL16UTF16.
I did manage to save
thanks it worked :)
but i had a problem with the MYSQl DSN
i had to install MySQL Connector/J 3.0.17 ( only this version has worked with
me)
thank you
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238531
i have a problem with inserting Arabic data into my database
i'm using Apache, MySql 4.0.24-nt, Coldfusion MX 6.1, on Windows XP Pro sp2
i did everything to enforce my application to use the UTF-8 charset
i used cfcontent type=text/html; charset=utf-8
and cfprocessingDirective
manar droubi wrote:
i'm using Apache, MySql 4.0.24-nt, Coldfusion MX 6.1, on Windows XP Pro sp2
You should use MySQL 4.1 or newer when you work with Unicode.
i used cfcontent type=text/html; charset=utf-8
and cfprocessingDirective pageencoding=utf-8
and cfset setEncoding(form,utf-8)
i
manar droubi wrote:
useUnicode=turecharacterEncoding=UTF-8
and the above should be
useUnicode=truecharacterEncoding=UTF-8
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238471
Archives:
Jillian Koskie wrote:
I'm moving an application from CF 5 to CFMX... and I'm having a problem
with some of my data.
The database is PostgreSQL.
For posterity:
The database was originally using the encoding SQL-ASCII. With CF
5 this results in characters with accents being treated as
Jillian Koskie wrote:
I'm moving an application from CF 5 to CFMX... and I'm having a problem
with some of my data.
The database is PostgreSQL.
How do I start tracking down the problem / fix it?Any tips?
What charset is your website using?
What charset was your website using in CF 5?
Are
the offending characters in PostgreSQL itself?
--
Jillian
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: September 1, 2004 6:01 AM
To: CF-Talk
Subject: Re: Unicode Problem
Jillian Koskie wrote:
I'm moving an application from CF 5 to CFMX... and I'm having a
problem
Jillian Koskie wrote:
We are not forcing a charset at all --whatever the default is.We are
not using cfprocessingdirective, setencoding or cfsetting.
Then you are probably using UTF-8 now.
My problem isn't so much 'how will I insert data now'... so much as
there is data in my database that
I have a database in sql_ascii. (though we've tried unicode as well)
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: September 1, 2004 9:52 AM
To: CF-Talk
Subject: Re: Unicode Problem
Jillian Koskie wrote:
We are not forcing a charset at all --whatever
Jillian Koskie wrote:
I have a database in sql_ascii. (though we've tried unicode as well)
That will only be able to correctly store characters from 7-bit
ASCII (so no accented characters). You need to convert your
database to unicode in order to be able to use unicode. For that,
pg_dump it,
characters in your database). You could also use another
supported charset like ISO-8859-15, but once you are converting
it is probably best to go all the way and switch to unicode.
ah, there's a man who knows a thing or two
[Todays Threads]
[This Message]
[Subscription]
[Fast
Jochem,
Is there any way to search my database for the offending records?
--
Jillian
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: September 1, 2004 10:25 AM
To: CF-Talk
Subject: Re: Unicode Problem
Jillian Koskie wrote:
I have a database in sql_ascii
Jillian Koskie wrote:
Is there any way to search my database for the offending records?
Perhaps the following would work:
SELECT ID
FROM table
WHERE octet_length(field) octet_length(convert(field, 'UNICODE'))
But don't continue with a hodgepodge. Bite the bullet, convert
your system to
Paul Hastings wrote:
characters in your database). You could also use another
supported charset like ISO-8859-15, but once you are converting
it is probably best to go all the way and switch to unicode.
ah, there's a man who knows a thing or two
Well, to quote a famous CF I18N Guru:
I'm moving an application from CF 5 to CFMX... and I'm having a problem
with some of my data.
The database is PostgreSQL.
How do I start tracking down the problem / fix it?Any tips?
The error:
Error Executing Database Query.
Invalid character data was found. This is most likely caused by
Toby Tremayne wrote:
I wonder though whether it's a CF thing or a copy/paste thing - can
encoding elements from word be pasted into a plain textarea on a
website? Or is it more likely that the earlier version of CF stored
things incorrectly and cfmx finally does it right?
More likely that
mmm perhaps you're right. I'm going to try this http posting thing
and see if it works...
Wednesday, January 29, 2003, 8:01:18 PM, you wrote:
JvD More likely that earlier versions didn't handle unicode right. Feel free
JvD to copy-paste all the Word stuff you want at
Hi Jochem,
jotn What charset is this data using?
ach - just whatever the default is for cf 4.0 /4.5 (UTF-8?) There
were no processing directives or locale settings in the app at all.
It's been running on a windows machine (NT) up to now.
jotn If the data in Access is visible correctly when
ok I've tried this again and have some interesting results. I used
pgAdmin's migration tool to try to move the data across - I created
the pg database as unicode, and used the unicode option for the
migration - and ended up with an error:
An error occured at: 29/01/2003 11:11:54 AM:
-2147467259:
Toby Tremayne wrote:
ok I've tried this again and have some interesting results. I used
pgAdmin's migration tool to try to move the data across - I created
the pg database as unicode, and used the unicode option for the
migration - and ended up with an error:
An error occured at:
argh. I had begun to think it might be something like this. i'll
keep playing but I fear you're right, the only way to rectify this is
have an older version of CF pull it out and post it to cfmx on another
server. What a nightmare.
I wonder though whether it's a CF thing or a copy/paste thing
Hi there, I am new to CF and I want to create a page with login and password. Can any
one help me with this. I will be very thankful.
Sangeeta
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
Quoting Toby Tremayne [EMAIL PROTECTED]:
I've been searching through the online forums and docs but can't
find anything that actually tells me how to do this. I have a
database (msaccess) full of data stored by a cf application being
run under 4.5 for most of it's life then cf
Hi all,
I've been searching through the online forums and docs but can't
find anything that actually tells me how to do this. I have a
database (msaccess) full of data stored by a cf application being
run under 4.5 for most of it's life then cf 5.0 for a while.
When I transport
Has anyone got any suggestions?
setup a template on the cf4.5 box that dumps out your data, that should get
the mangled unicode out ok. cfhttp from the mx box to that template, that
should get it into real unicode format. make sure the mx dsn has unicode
option turned on you've added
Hi Paul,
thanks for that. It's not going to be fun re-writing my scripts to
scrape all this data off a cfhttp call though
incidentally will I need to cfprocessingdirective, setencoding, etc
on every page in my cfmx application from now on? I saw something
the other day
thanks for that. It's not going to be fun re-writing my scripts to
scrape all this data off a cfhttp call though
well you might try cf4.5 to dump out text files use native db tools to
import these.
incidentally will I need to cfprocessingdirective, setencoding, etc
good
PH good practice for cfprocessingdirective on each page. setencoding, cfcontent
PH can just go into the application.cfm
That's what's bothering me Paul - can I no longer just output the data
from my database reliably without forcing these directives?
Friday, January 24, 2003, 4:40:52 PM, you
That's what's bothering me Paul - can I no longer just output the data
from my database reliably without forcing these directives?
it, as usual, depends on what specifically you're doing. what encoding do
you want to use? what encoding is your cf box's jvm? want i18n?
ach to be honest I'm just want it to pump out the data in whatever the
default is - there's a lot of data but it's not an enormous
application, and the content is all straight english text.
Friday, January 24, 2003, 5:29:16 PM, you wrote:
That's what's bothering me Paul - can I no longer just
ach to be honest I'm just want it to pump out the data in whatever the
default is - there's a lot of data but it's not an enormous
application, and the content is all straight english text.
its not likely that its all straight english text if you're getting ? []
in your text. you've probably
Hi,
I really hope that somebody can shed some light with this issue (Hint, hint
Macromedia)
We have one application that was fully translated in Korean (using CF5)
With CFMX the previously translated data cannot be properly display by CFMX
, so we had to manually retrieve the data and re save
Marius Milosav wrote:
I really hope that somebody can shed some light with this issue (Hint, hint
Macromedia)
I doubt you will see something from Macromedia here. Maybe from
Macromedia employees, but that is not the same.
We have one application that was fully translated in Korean (using
and everything works OK
Thanks
Marius
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 1:35 PM
Subject: Re: CFMX unicode problem
Marius Milosav wrote:
I really hope that somebody can shed some light with this issue
With CFMX the previously translated data cannot be properly display by
CFMX
, so we had to manually retrieve the data and re save it.
actually you could have cfhttp-ed into the cf5 box from mx slurped over
the data.
On our development server CFMX version 6,0,0,48097 the data is properly
Missing info on locales of all machines involved (CF SQL), datatypes
(N or normal), use of setEncoding, use of cfcontent, use of
cfprocessingdirective. (All these CF functions are explained in the
internationalization docs on the Macromedia website:
On Tuesday, September 10, 2002, at 10:25 , Marius Milosav wrote:
On their server the data is properly displayed in Korean but all new data
that is saved it display garbage.
Note that when moving to CFMX, you need to add several pieces of code to
your pages if you wish to handle non-Latin-1
]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 2:21 PM
Subject: Re: CFMX unicode problem
Missing info on locales of all machines involved (CF SQL), datatypes
(N or normal), use of setEncoding, use of cfcontent, use of
cfprocessingdirective. (All these CF functions
Just to follow-up to this:
As we state in the docs, when two CFM files contain different character encodings, but
a BOM is missing from one or more of the .CFM files, AND no CFPROCESSINGDIRECTIVE is
specified, the default OS encoding will be used.
This basically tells the CFMX compiler,
40 matches
Mail list logo