Re: [WebDNA] UTF-8 encoding issues
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104560
interpreted = N
texte = DonovanBest to work from the original. I went through charset hell a few years ago before I switched everything to UTF8.- TomSent from my iPhoneOn 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:
DonovanBest to work from the original. I went through charset hell a few years ago before I switched everything to UTF8.- TomSent from my iPhoneOn 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)