Re: [WebDNA] UTF-8 encoding issues
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104559
interpreted = N
texte = 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]**
Associated Messages, from the most recent to the oldest:
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]**
Donovan Brooke
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:
Rhapsody? (1997)
Re:quit command on NT (1997)
When is unitShipCost calculated? (1998)
[WebDNA] Flippage & SWCTools (2010)
Help w/ Duplicating The General Store 5 times. (1997)
Date search - yes or no (1997)
Re:no [search] with NT (1997)
Slow Code, how to speed up (2002)
WebDelivery downloads alias, not original ? (1997)
Date search - yes or no (1997)
displaying [cart] contents with a pull-down & frames (1998)
[random] only for 1-100??? (1997)
Balancing randomness (2000)
Max Record length restated as maybe bug (1997)
Fun with dates (1997)
more on prefs not being written (2000)
Getting it as [raw] (2004)
forms and variables (1998)
Where is f2? (1997)
webcat- multiple selection in input field (1997)