I just tried to run an installer on a client's server, where that
installer runs some cfqueries that create tables. Its a CF5/mySQL4
box, where I installed the latest mySQL odbc and db maybe a month ago.
I created the mySQL dsn in the Windows ODBC applet as was normal in
the olden days.
Running
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 n
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
> >>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 int
> >>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 int
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?
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,
> 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 mes
> >Try adding "useUnicode=true&characterEncoding=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]
>Try adding "useUnicode=true&characterEncoding=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]
>> 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 a
> 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 kn
Try adding "useUnicode=true&characterEncoding=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:
> Any
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 po
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 ju
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 t
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 and
> 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 la
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
no
turday, 29 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&
7:48 PM
To: CF-Talk
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 t
> > 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 ad
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)?
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 Devel
25 matches
Mail list logo