Re: [WebDNA] UTF-8 encoding issues

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104560
interpreted = N
texte = Donovan Best to work from the original. I went through charset hell a few years ago before I switched everything to UTF8. - Tom Sent from my iPhone On 22 Jan 2010, at 22:01, Donovan Brooke wrote: > Tom Duke wrote: >> 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 > > Hi Tom, this is the way I converted it originally.. but I may > have saved an intermediate step or something with a 3rd party > encoding? !@#$... :-/ > Now I have a mess to deal with. > > Anyway, I tried a command-line utility called iconv that is > on the latest macs. It had a '-c' flag that was supposed to > simply not add the characters that would not convert to the encoding > you are shooting for.. however, I think my database was too messed > up already for that to work. > > ..now going back to an old database, then rebuild from there. :-/ > ...not what I wanted to do on late friday. > > Donovan > > > -- > Donovan Brooke > WebDNA Software Corporation > http://www.webdna.us > **[Square Bracket Utopia]** > --------------------------------------------------------- > 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 Best to work from the original. I went through charset hell a few years ago before I switched everything to UTF8. - Tom Sent from my iPhone On 22 Jan 2010, at 22:01, Donovan Brooke wrote: > Tom Duke wrote: >> 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 > > Hi Tom, this is the way I converted it originally.. but I may > have saved an intermediate step or something with a 3rd party > encoding? !@#$... :-/ > Now I have a mess to deal with. > > Anyway, I tried a command-line utility called iconv that is > on the latest macs. It had a '-c' flag that was supposed to > simply not add the characters that would not convert to the encoding > you are shooting for.. however, I think my database was too messed > up already for that to work. > > ..now going back to an old database, then rebuild from there. :-/ > ...not what I wanted to do on late friday. > > Donovan > > > -- > Donovan Brooke > WebDNA Software Corporation > http://www.webdna.us > **[Square Bracket Utopia]** > --------------------------------------------------------- > 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:

WebCat2: multiple currency support (1997) [WebDNA] An unknown error occured // Deadlock avoided (2011) Listserver problem (1997) formatting dates from a field ... (1997) Sort Order on a page search (1997) Unzip (2005) Extended [ConvertChars] (1997) Summing fields (1997) OT: Log Files (2003) Session Number (1998) Sorting by number (2001) WebMerchant - MacAuthorize (1999) Quantity (1998) [WriteFile] problems (1997) Deleting Orders (1997) Upgrading old WebCat Database Files (1997) DNS Lookup 2 (2000) Macs and SQL (2000) Another question (1997) Understanding texta (1997)