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 5.0 for a while.
What charset is this data using? > When I transport the data from the access DB to my new postgres DB > on a linux server I use a CF script, as the table structure has > changed - that script is run on the windows machine. All runs > fine, but when I go to view the application from the new > installation it's full of junk characters (square symbols and > questrion marks). I'm assuming this is something to do with the > fact that earlier versions of cf screwed up the unicode encoding > and cfmx apparently has gotten it right - but I can't find anything > on a method for fixing this! If the data in Access is visible correctly when using Access it self it is not a normal unicode issue. Which CF version did you use to move the data? Which client_encoding did you set in PostgreSQL during the migration? Did you set up the PostgreSQL database to use unicode (WITH ENCODING 'UNICODE')? Can't you use the pgAdmin database migration wizard to move the data from Access to PostreSQL and then use built-in functionality to transform the data? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
