Re: [WebDNA] UTF-8 encoding issues

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104556
interpreted = N
texte = Donovan The easiest way to do a charset conversion is to open the db in BBedit using the correct charset. If there are dodgy characters after you open it then BBedit has a reopen using encoding option in one of the menus. Try different ones until the db looks ok. Then change the charset using the menu at the bottom of the BBedit window (UTF8- no bom) and bingo your db is in Utf8. - Tom Sent from my iPhone On 22 Jan 2010, at 20:10, Donovan Brooke wrote: > Hello!, > > I have an 8MB products (WebDNA) database that I recently re-encoded > to UTF-8 from what used to most likely be a Mac Western > type of encoding. Since the product descriptions were > copy/pasted by mac users to the site CMS (from who knows what type > of desktop application), there are some issues now with > certain characters after the conversion. > > I am looking for ideas on how best to deal with those odd non > UTF-8 characters without having to manually edit 3K records. > > I suppose if there were a list of UTF-8 characters that differ from > Western Characters, I could write up a script to do a conversion.. > but that is about my only idea right now. > > Thanks for any ideas! > > Donovam > > > > > -- > Donovan Brooke > Euca Design Center > [Practical-Ethical-Efficient] > www.euca.us > egg.bz > artglass-forum.com > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] UTF-8 encoding issues (Donovan Brooke 2010)
  2. Re: [WebDNA] UTF-8 encoding issues (Christer Olsson 2010)
  3. Re: [WebDNA] UTF-8 encoding issues (Kenneth Grome 2010)
  4. Re: [WebDNA] UTF-8 encoding issues (Marc Thompson 2010)
  5. Re: [WebDNA] UTF-8 encoding issues (Kenneth Grome 2010)
  6. Re: [WebDNA] UTF-8 encoding issues (Tom Duke 2010)
  7. Re: [WebDNA] UTF-8 encoding issues (Donovan Brooke 2010)
  8. Re: [WebDNA] UTF-8 encoding issues (Govinda 2010)
  9. Re: [WebDNA] UTF-8 encoding issues (Kenneth Grome 2010)
  10. Re: [WebDNA] UTF-8 encoding issues (Tom Duke 2010)
  11. Re: [WebDNA] UTF-8 encoding issues (Govinda 2010)
  12. Re: [WebDNA] UTF-8 encoding issues (Donovan Brooke 2010)
  13. [WebDNA] UTF-8 encoding issues (Donovan Brooke 2010)
Donovan The easiest way to do a charset conversion is to open the db in BBedit using the correct charset. If there are dodgy characters after you open it then BBedit has a reopen using encoding option in one of the menus. Try different ones until the db looks ok. Then change the charset using the menu at the bottom of the BBedit window (UTF8- no bom) and bingo your db is in Utf8. - Tom Sent from my iPhone On 22 Jan 2010, at 20:10, Donovan Brooke wrote: > Hello!, > > I have an 8MB products (WebDNA) database that I recently re-encoded > to UTF-8 from what used to most likely be a Mac Western > type of encoding. Since the product descriptions were > copy/pasted by mac users to the site CMS (from who knows what type > of desktop application), there are some issues now with > certain characters after the conversion. > > I am looking for ideas on how best to deal with those odd non > UTF-8 characters without having to manually edit 3K records. > > I suppose if there were a list of UTF-8 characters that differ from > Western Characters, I could write up a script to do a conversion.. > but that is about my only idea right now. > > Thanks for any ideas! > > Donovam > > > > > -- > Donovan Brooke > Euca Design Center > [Practical-Ethical-Efficient] > www.euca.us > egg.bz > artglass-forum.com > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 Tom Duke

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[WebDNA] Integrating with WP and PHP (2011) OT: Log Files (2003) A dynamic database. (1997) Reversed words (1997) Using Applescript to process WebCatalog functions (1998) absolute paths for databases? (1997) PCS Emailer's role ? (1997) WebTen and WebCat (1997) search vs lookup (1998) Spaces inside [AppendFile] (1998) Dynamic PDFs? (2002) Show shoppingcart after remove last item (1997) Replace Statement (1997) The Guru Speaks-Is That Really the Only Manuel? (1998) WebCat2 - many [carts] on one template page? (1997) popups, netscape vs explorer (1997) [WebDNA] Encrypting INCLUDE files (2018) Snake Bites (1997) Help! WebCat2 bug (1997) b12 cannot limit records returned and more. (1997)