Re: [WebDNA] UTF-8 encoding issues
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104564
interpreted = N
texte = Thanks Marc, I've seen that before. What I have not seen is a database that contains all the unicode characters.Sincerely,Kenneth Gromewww.KenGrome.com> Here's some good reference material:> http://unicode.org/resources/utf8.html> > Kenneth Grome wrote:> > Is there a database (not a 'cheat sheet' online somewhere that has all the UTF-8 characters in it? I was looking for one a while ago and never found one, but having one might make converting to them easier.> > > > Sincerely,> > Kenneth Grome> > www.KenGrome.com> > > > > > > > > > > > > > > >> 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> >> ---------------------------------------------------------> >> 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> >>> > > > ---------------------------------------------------------> > 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:
Thanks Marc, I've seen that before. What I have not seen is a database that contains all the unicode characters.Sincerely,Kenneth Gromewww.KenGrome.com> Here's some good reference material:> http://unicode.org/resources/utf8.html> > Kenneth Grome wrote:> > Is there a database (not a 'cheat sheet' online somewhere that has all the UTF-8 characters in it? I was looking for one a while ago and never found one, but having one might make converting to them easier.> > > > Sincerely,> > Kenneth Grome> > www.KenGrome.com> > > > > > > > > > > > > > > >> 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> >> ---------------------------------------------------------> >> 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> >>> > > > ---------------------------------------------------------> > 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> > .> > >
Kenneth Grome
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:
Nested ListFiles (1998)
Check for OS (2003)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
Up and running ... at last !! (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
multiple search commands (1997)
[WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019)
[WebDNA] v 7 append (2012)
A question on sub-categories (1997)
[subtotal] and others (1997)
Date Range search (1997)
I'm tired of all this! (2000)
price carry over (1997)
different show next (1997)
[WebDNA] securing passing info from php to webdna (2011)
Problems reading files created by WC (1997)
Updating a database once per day - An example (1998)
Can't use old cart file (was One more try) (1997)
[SearchString] usage (1997)
Formatting a .txt file (1998)