thanks guys, still having trouble but have managed to upload content directly
to the database (bypassing cms). tiny mce seems to be my problem now as it
converts the correct content back to something else then i am back at the start.
arrghh.
Might want to post *that* question to the TinyMCE forums...?
http://tinymce.moxiecode.com/punbb/
(I looked through http://wiki.moxiecode.com/index.php/TinyMCE:Index and did
not see anything obvious.)
On Thu, Feb 19, 2009 at 2:21 AM, Mike Little m...@nzsolutions.co.nz wrote:
thanks guys,
hi guys,
i have the following textg to insert into a mysql db...
Mastering macrons in te reo MÄori.Keke or kÄkÄ? Cake or armpit?
the data is being turned into...
Mastering macrons in te reo M?ori. Keke or k?k?? Cake or armpit?
i have just attempted to change the column charset to utf8,
aha, i see it has done the same on this site. basically the characters have
accents on them.
mike
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
In MS SQL Server, solution is to use nvarchar instead of varchar and ntext
instead of text. Not sure about MySQL...
On Wed, Feb 18, 2009 at 6:42 AM, Mike Little m...@nzsolutions.co.nz wrote:
aha, i see it has done the same on this site. basically the characters have
accents on them.
mike
from what i can see ntext is not supported in mysql john.
i am using mysql 4.1 by the way.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://forums.mysql.com/read.php?103,2074,2233#msg-2233
On Wed, Feb 18, 2009 at 6:52 AM, Mike Little m...@nzsolutions.co.nz wrote:
from what i can see ntext is not supported in mysql john.
i am using mysql 4.1 by the way.
Since it sounds like you've already got the column set to receive UTF-8, you'll
need to ensure that you're also coding the data going into the database and
being displayed. Drop this in your application file or at the top of your
global index file or wherever:
this codes the characters when
MySQL 4.1 does support unicode, not sure if it uses nvarchar/ntext/etc though.
Here is some info on the improvements between 4.0 and 4.1
http://dev.mysql.com/tech-resources/articles/4.1/unicode.html
~|
Adobe® ColdFusion® 8
Mike Little wrote:
can anyone see what i may be doing wrong?
what db driver (ie JDBC or ODBC, should be JDBC driver)? what ver of cf (should
be something newer than cf5)?
can you post the input code?
~|
Adobe® ColdFusion® 8
With Mysql 5 and CF 8 I needed to add this connection string to the
datasource:
jdbc:mysql://
127.0.0.1:3306/utf8demo?allowMultiQueries=truecharacterEncoding=UTF8characterSetResults=UTF8
Also the charset I used in MySql was: utf8
the colation was: utf8_general_ci;
After that I was able to
11 matches
Mail list logo