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.> > - TomHi Tom, this is the way I converted it originally.. but I mayhave saved an intermediate step or something with a 3rd partyencoding? !@#$... :-/Now I have a mess to deal with.Anyway, I tried a command-line utility called iconv that ison the latest macs. It had a '-c' flag that was supposed tosimply not add the characters that would not convert to the encodingyou are shooting for.. however, I think my database was too messedup 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 BrookeWebDNA Software Corporationhttp://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.> > - TomHi Tom, this is the way I converted it originally.. but I mayhave saved an intermediate step or something with a 3rd partyencoding? !@#$... :-/Now I have a mess to deal with.Anyway, I tried a command-line utility called iconv that ison the latest macs. It had a '-c' flag that was supposed tosimply not add the characters that would not convert to the encodingyou are shooting for.. however, I think my database was too messedup 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 BrookeWebDNA Software Corporationhttp://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:
[WebDNA] help with writefile (2012)
FTP and [shell] (2003)
Mac OS and 3.0.5b12 bug report (1999)
How to include weather (2000)
How true is this? (1999)
lookup command (1999)
A Toughie (1998)
[WebDNA] EMailFolder/ (2016)
question: webmerchant connection (1997)
GuestBook example (1997)
RE: redirect with more than 256 characters (1999)
[include] affect on filepaths for links? (1997)
Webcatalog server support (1997)
DON'T use old cart file! (1997)
WebDNA creates DUPLICATE SHOPPING CART NUMBERS (2004)
Problem when Inputing text (1999)
sort problems....bug or brain fart? (1997)
WCS Newbie question (1997)
Search returns all, not 20 (1997)
UPDATE PROBLEM (1997)