an easy way to replace characters in a MySQL database
Hello, Is there an easy way to replace characters in textfields of a mysql database? We want to replace curly quotes with a 'normal' single quotes. These quotes came in the database by pasting data from a Word document. Are there mysql admin tools available that make this as simple as a find and replace in a regular text editor? Or is it possible to do this directly in SQL? We use phpMyAdmin to administer our database. regards, Frederik Frederik Van Goolen project ingenieur Technopolis Technologielaan 2800 Mechelen tel (32) (0)15 34 20 20 fax (32) (0)15 34 20 10 mailto:[EMAIL PROTECTED] http://www.technopolis.be De bovenvermelde berichten/tekst en bijlagen verbinden Stichting F.T.I/Technopolis op geen enkele wijze, tenzij anders werd overeengekomen bij een schriftelijke overeenkomst of tenzij zij later worden bevestigd bij een overeenkomstig de wettelijke voorschriften ondertekende brief. Evenmin kunnen Stichting F.T.I/Technopolis aansprakelijk worden gesteld op grond van de inhoud van deze berichten/tekst en bijlagen. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfc, flash remoting and character set problems
Thank you all, the problem was indeed the fact that we copy-pased our data from Word in the database. Replacing the curly quotes solved the problem. Frederik >On Thu, 2004-03-11 at 09:39, Burns, John wrote: >> Rob, >> >> What range would these "invalid MS word characters" fall into? > >I believe they actually map to control characters IIRC > >"... >* Long dashes >* Curly single quotes >* Trademark symbol >True Type fonts in Microsoft Windows systems use a superset of ISO >Latin-1 to get these special characters. In basic Latin-1, the numeric >characters 128-159 are left open, but Windows systems use them to create >custom characters that usually are only visible on Windows operating >systems - and even there, display isn't always consistent. ..." >- some google page > >-- >Rob <[EMAIL PROTECTED]> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfc, flash remoting and character set problems
We found a solution for this problem on the folowing pages: http://forums.devshed.com/t112715/sdb8be35112ed57bd850c5f26231a88fa.html and http://www.dialoguedesigns.co.uk/dc2/page.cfm?pageid=cfmxproblems Last week I made a post on this list with the solution: http://www.houseoffusion.com/lists.cfm/link=m:4:30992:155343 good luck! Frederik [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfc, flash remoting and character set problems
Hello, We have a flash remoting application that talks with a cfc. The cfc gets some (multi language) data from a MySQL database. We get the data properly in Coldfusion (we checked this by invoking the cfc with a browser and the query). When the data is in Flash however some characters are corrupted. We forced coldfusion to use the ISO-8859-1 charset, because MySQL uses this characterset by default. So the problem is probably the flash remoting service which uses another characterset to transport the data from Coldfusion to Flash. Now the question: is it possible to force the output of the cfc to another charset (UTF-8, the one Flash is using, we assume)? Or does anybody know a way to force Flash Remoting to another character set? Any help is appreciated! regards, Frederik Van Goolen project ingenieur Technopolis Technologielaan 2800 Mechelen tel (32) (0)15 34 20 20 fax (32) (0)15 34 20 10 mailto:[EMAIL PROTECTED] http://www.technopolis.be De bovenvermelde berichten/tekst en bijlagen verbinden Stichting F.T.I/Technopolis op geen enkele wijze, tenzij anders werd overeengekomen bij een schriftelijke overeenkomst of tenzij zij later worden bevestigd bij een overeenkomstig de wettelijke voorschriften ondertekende brief. Evenmin kunnen Stichting F.T.I/Technopolis aansprakelijk worden gesteld op grond van de inhoud van deze berichten/tekst en bijlagen. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
internationalisation problem: solved
Hello, Yesterday I posted a problem about displaying French characters (é, à, ...) coming out of a MySql database. Today I found the (not obvious) solution, posted on this URL: http://www.dialoguedesigns.co.uk/dc2/page.cfm?pageid=cfmxproblems This is the solution: 1. In the ColdFusion MX Administrator open the datasource properties for your MySql datasource, click on Advanced Properties, and put the following in the 'connection string' box: useUnicode=true&characterEncoding=iso-8859-1 2. Place the following in application.cfm: 3.(optional) At the top of each cfm page you should add: In my case it worked also without (3). I hope this will safe others from a full day of struggling... regards, Frederik Van Goolen project ingenieur Technopolis Technologielaan 2800 Mechelen tel (32) (0)15 34 20 20 fax (32) (0)15 34 20 10 mailto:[EMAIL PROTECTED] http://www.technopolis.be De bovenvermelde berichten/tekst en bijlagen verbinden Stichting F.T.I/Technopolis op geen enkele wijze, tenzij anders werd overeengekomen bij een schriftelijke overeenkomst of tenzij zij later worden bevestigd bij een overeenkomstig de wettelijke voorschriften ondertekende brief. Evenmin kunnen Stichting F.T.I/Technopolis aansprakelijk worden gesteld op grond van de inhoud van deze berichten/tekst en bijlagen. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: (custom) tag to convert text to html
Stephen, Database: MySQL 4.014 In the mean time I noticed that when I the query that the special characters are already messed up. I used phpMyAdmin to enter the French sentences, and when I look and the content with phpMyAdmin, it looks ok (special characters are ok). So it must be something that happens when CF receives the query. To be honest, I don't know how to set up a character coding set in the database. Frederik [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
(custom) tag to convert text to html
Hello there, Is there an easy way to automatically convert text out of a database into html? We have an application in different languages where some text elements are in the database. Now we have a problem with French since it uses a lot of 'é' and 'à', which need to be converted to a character entity for proper display in html. Does anybody know of a (custom) tag that can do this automatically? Thanks! regards, Frederik Van Goolen project engineer Technopolis Technologielaan 2800 Mechelen Belgium tel (32) (0)15 34 20 20 fax (32) (0)15 34 20 10 mailto:[EMAIL PROTECTED] http://www.technopolis.be De bovenvermelde berichten/tekst en bijlagen verbinden Stichting F.T.I/Technopolis op geen enkele wijze, tenzij anders werd overeengekomen bij een schriftelijke overeenkomst of tenzij zij later worden bevestigd bij een overeenkomstig de wettelijke voorschriften ondertekende brief. Evenmin kunnen Stichting F.T.I/Technopolis aansprakelijk worden gesteld op grond van de inhoud van deze berichten/tekst en bijlagen. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]