the installer yields this :
The SQL operation you specified is unrecognized (only SELECT, INSERT,
UPDATE, DELETE, and CALL are supported).
The CF Admin control page for this dsn only has checkboxes for
allowing/disallowing select, insert, update and delete.
Is that normal?no table creation in CF5
dan martin wrote:
The data is UTF-8 (sorry for the misnamed subject).
The cf code and the php code do the same thing:
set var1=utf8 thai string
set var2=utf8 ukraine string
It seems like the cf should work
No, it shouldn't. CF5 does not support unicode. MySQL does not
support
dan martin said:
Can you explain/expand upon what you mean by some of them are
broken in the same way?
One makes a mistake while encoding it, and the other one makes the
same mistake while decoding it.
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
dan martin wrote:
The data is UTF-8 (sorry for the misnamed subject).
The cf code and the php code do the same thing:
set var1=utf8 thai string
set var2=utf8 ukraine string
It seems like the cf should work
No, it shouldn't. CF5 does not support unicode. MySQL does not
support
Anyone know the trick to get utf-8 data stored in a database to display
properly in cf-5?
it never will properly. i could get text into/out of a db (sql server) as
utf-8 ok but no cf string functions will work with it--cf5 pretty much
ignored char encodings just used iso-8859-1. as far as i
Try adding useUnicode=truecharacterEncoding=UTF8 to the connection
Barney, thanks for the suggestion. It didnt seem to have any effect though.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Try adding useUnicode=truecharacterEncoding=UTF8 to the connection
Barney, thanks for the suggestion. It didnt seem to have any effect
though.
that's for jdbc driver.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
The utf-8 characters store properly in the database because I can retreive
and display them properly using php. When I retreive them from cf5 they show
the squares. Before I insert them, on the same page, cf5 *does* display
utf-8 properly. It is only the retreived data (via cf5) that seems to
The utf-8 characters store properly in the database
UTF-8 or Unicode?
If you store UTF-8 in the database, there should not be any problem with CF 5, since UTF-8 is supported by plain vanilla ASCII.
Just add the correct character set in your meta tags.
If it is Unicode, then it is another story,
Claude Schneegans wrote:
The utf-8 characters store properly in the database
UTF-8 or Unicode?
If you store UTF-8 in the database, there should not be any problem with CF 5, since UTF-8 is supported by plain vanilla ASCII.
Just add the correct character set in your meta tags.
If it is
The utf-8 characters store properly in the database
UTF-8 or Unicode?
The data is UTF-8 (sorry for the misnamed subject).
The cf code and the php code do the same thing:
set var1=utf8 thai string
set var2=utf8 ukraine string
display var1, var2 to screen (cf5, php both work)
insert into
The utf-8 characters store properly in the database
UTF-8 or Unicode?
The data is UTF-8 (sorry for the misnamed subject).
The cf code and the php code do the same thing:
set var1=utf8 thai string
set var2=utf8 ukraine string
display var1, var2 to screen (cf5, php both work)
insert into
Anyone know the trick to get utf-8 data stored in a database to display properly in cf-5?
I can display text in kanji and all the other languages fine, and can store them properly in the mysql database. When I display the data from the database in cf, they are displayed as squares.
I have seen
Try adding useUnicode=truecharacterEncoding=UTF8 to the connection
string field on the datasource's advanced settings page.I don't know
if CF5 has such a thing though, so you might not be able to.
cheers,
barneyb
On Wed, 18 Aug 2004 16:37:46 -0400, dan martin [EMAIL PROTECTED] wrote:
Anyone
Anyone know the trick to get utf-8 data stored in a database to display
properly in cf-5?
it never will properly. i could get text into/out of a db (sql server) as
utf-8 ok but no cf string functions will work with it--cf5 pretty much
ignored char encodings just used iso-8859-1. as far as i
Jim McAtee wrote:
I see. So, regarding my question about using ODBC style dates with the
'native' jdbc drivers - do the drivers understand ODBC formatted date/times or
do they just pass queries verbatim to the dbms, forcing you to comply with the
particular formats of the database?
JDBC
:[EMAIL PROTECTED]
Sent: Thursday, July 10, 2003 4:22 AM
To: CF-Talk
Subject: Re: CF5 to MySQL without ODBC
Jim McAtee wrote:
I see. So, regarding my question about using ODBC style dates with the
'native' jdbc drivers - do the drivers understand ODBC
formatted date/times or
do
Versoin 3.23.49-nt. Any recommendations for or against moving to MySQL 4.0?
- Original Message -
From: Matt Robertson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 11:37 PM
Subject: RE: CF5 to MySQL without ODBC
It shouldn't be slower than Access
-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: 09 July 2003 06:59
To: CF-Talk
Subject: Re: CF5 to MySQL without ODBC
Versoin 3.23.49-nt. Any recommendations for or against moving to MySQL
4.0?
- Original Message -
From: Matt Robertson [EMAIL PROTECTED]
To: CF-Talk [EMAIL
Versoin 3.23.49-nt. Any recommendations for or against moving to MySQL
4.0?
That's not the last but one of the later versions. 3.23.53 was the last
one I remember seeing.
I would absolutely upgrade.
One thing 4.x has over 3.x is a cache that cranks speed up
significantly. Also 4.x is now
Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax : 360.647.5351
www.audiencecentral.com
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 9:28 AM
To: CF-Talk
Subject: RE: CF5 to MySQL
PROTECTED]
Sent: Wednesday, July 09, 2003 9:46 AM
To: CF-Talk
Subject: RE: CF5 to MySQL without ODBC
One thing to watch is dates. If you're using datetime columns, you can
no
longer specify a date like this:
20030709
You have to make it a string, and 14 digits long (to include the time
: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 9:46 AM
To: CF-Talk
Subject: RE: CF5 to MySQL without ODBC
One thing to watch is dates. If you're using datetime columns, you can
no
longer specify a date like this:
20030709
You have to make it a string, and 14
Barney Boisvert wrote:
where datefield between '2002:07:09 00:00:00' and '2003:07:09 00:00:01'
The delimiter used is inconsequential, you can use pretty much any
punctuation character, and you can use several in a single value (2003:07/09
00+00-00). I use colons throughout for
, 2003 11:47 AM
Subject: RE: CF5 to MySQL without ODBC
Yeah, that'll work on both 3.x and 4.x, assuming you get the leading
apostrophe on the second number in there ; )
In 3.x omitting the quotes would also work, but not in 4.x, unless it's a
date column (rather than datetime). The reason
: 360.756.8080 x12
fax : 360.647.5351
www.audiencecentral.com
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 5:27 PM
To: CF-Talk
Subject: Re: CF5 to MySQL without ODBC
Maybe I'm missing something, but if we're talking about CF5
: Wednesday, July 09, 2003 6:39 PM
Subject: RE: CF5 to MySQL without ODBC
If that assumption is something you can live with. However, as soon as you
upgrade to CFMX, ODBC goes away, at least for connecting to MySQL, which
would require yet another rewrite of the date code. Ouch
Jim wrote, perplexed:
So CFMX has a native driver for MySQL?
Sorta kinda. It's the 'native' jdbc driver and it works just peachy.
I assumed that if you had been using the MyODBC driver with CF5, you
could continue to use it with CFMX?
Survey said... B. (:D) ODBC drivers are just flat
- Original Message -
From: Matt Robertson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 11:30 PM
Subject: RE: CF5 to MySQL without ODBC
Jim wrote, perplexed:
So CFMX has a native driver for MySQL?
Sorta kinda. It's the 'native' jdbc driver
We've begun moving a number of application databases from Access97 and
Access2000 to MySQL 3 and we're currently using the MyODBC 3.51 driver to work
with them from CF5. While I'm guessing that MySQL will behave much better than
Access under load, under light loads it's pretty easy to see that
McAtee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 10:25 PM
To: CF-Talk
Subject: CF5 to MySQL without ODBC
We've begun moving a number of application databases from Access97 and
Access2000 to MySQL 3 and we're currently using the MyODBC 3.51 driver
to work
with them from CF5. While I'm
Why would I not be able to select MySQL as a data provider under CF Admin
(version 5 - MX was even worse)?
I'm running Windows 2000 Advanced Server with IIS (fully patched - Broadband
is a godsend for that) and CF5 Professional.
Thanks!
==
Peter Tilbrook
Macromedia ColdFusion Applications
Peter Tilbrook wrote:
Why would I not be able to select MySQL as a data provider under CF Admin
(version 5 - MX was even worse)?
Because nobody ever bothered to write a plugin to add that option.
Jochem
__
This list and all
Why would I not be able to select MySQL as a data provider under CF
Admin
(version 5 - MX was even worse)?
last time i looked cfmx had native mySQL. i don't imagine thats worse.
__
Your ad could be here. Monies from ads go
Subject: Re: CF5 and MySQL
Peter Tilbrook wrote:
Why would I not be able to select MySQL as a data provider under CF Admin
(version 5 - MX was even worse)?
Because nobody ever bothered to write a plugin to add that option.
Jochem
June 2002 7:58 PM
To: CF-Talk
Subject: Re: CF5 and MySQL
Why would I not be able to select MySQL as a data provider under CF
Admin
(version 5 - MX was even worse)?
last time i looked cfmx had native mySQL. i don't imagine thats worse
It seems the belief at MM is that everyone who has used CF since, say like
myself, version 1 are commited by default to upgrade to the MX family of
products. ColdFusion MX has problems and in my opinion the decision to
discontinue development of HomeSite/ColdFusion Studio in its current form is
Can't affor MX as yet - I did try the trial version - not impressed enough
well from my i18n standpoint, this is the greatest thing since sliced bread.
what it doesn't do, with a few measly lines of newbie java i can get the
rest.
yet for the upgrade. The MM staff at the recent Australian
Have you downloaded and installed myODBC drivers from mySQL.com?
I have a similar setup as you and have no problems setting up mySQL as a
datasource.
-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 29, 2002 4:18 AM
To: CF-Talk
Subject: CF5
CF 5 and MySQL work fine together (and beats the heck out of using Access
IMO) as long as you have installed MyODBC that is. You have to set up
the DSN with the Windows Control Panel (not CF administrator).
HTH
Mike
_
Join
Peter Tilbrook wrote:
I've used it in the past so I'm mind boggled as to why it isn't available
now. I can use MSSQL which I have a licence for but wanted to write a
freeware application. Looks like I'll be developing under SQL Server.
There isn't one available for PostgreSQL either so I just
41 matches
Mail list logo
