Re: Unusual characters in the db ...
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42458
interpreted = N
texte = >>Does anyone know why the ñ (lowercase n-tilde) character that people >>type into my forms gets converted to Ò (uppercase O-acute) when it's >>stored in a db -- and what can I do to prevent this problem? > >ñ in Mac Roman is Ò in ISO-8859-1. Make sure data is entered with >the same character set as they're appended to the database. Search >the archives, I've posted the code for this some times. Hi Christer,The part of your instructions from the archives which are clear to me suggest that we put these tags on every page:[SETMIMEHEADER name=Content-Type&value=text/html; charset=iso-8859-1] [SETMIMEHEADER name=charset&value=iso-8859-1]Is this all there is to it? I mean, if this is all I do, will the ñ characters my visitors type into their browsers get stored properly in my webcat db's?The reason I ask is because I have no idea what you're getting at when you also say:Our policy is to store dbs as ISO-8859-1.So if there's something else that needs to be done in order for me to store my dbs as ISO-8859 -- in addition to using the [setmimeheader] tags shown above -- then maybe you can elaborate on the additional tasks I will need to perform ...Thanks!By the way, I've never had to use many [setmimeheader] tags before, so I have two questions regarding their use:1- If I start using them now, what will 'break' that used to work fine before I put them into all my webdna pages?2- isn't there certain times when you cannot use [setmimeheader] tags -- such as on the same page than has [setcookie] or [redirect] or [returnraw] tags in it? If anyone remembers please post your response or email me privately, thanks. Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>>Does anyone know why the ñ (lowercase n-tilde) character that people >>type into my forms gets converted to Ò (uppercase O-acute) when it's >>stored in a db -- and what can I do to prevent this problem? > >ñ in Mac Roman is Ò in ISO-8859-1. Make sure data is entered with >the same character set as they're appended to the database. Search >the archives, I've posted the code for this some times. Hi Christer,The part of your instructions from the archives which are clear to me suggest that we put these tags on every page:[SETMIMEHEADER name=Content-Type&value=text/html; charset=iso-8859-1] [SETMIMEHEADER name=charset&value=iso-8859-1]Is this all there is to it? I mean, if this is all I do, will the ñ characters my visitors type into their browsers get stored properly in my webcat db's?The reason I ask is because I have no idea what you're getting at when you also say:Our policy is to store dbs as ISO-8859-1.So if there's something else that needs to be done in order for me to store my dbs as ISO-8859 -- in addition to using the [setmimeheader] tags shown above -- then maybe you can elaborate on the additional tasks I will need to perform ...Thanks!By the way, I've never had to use many [setmimeheader] tags before, so I have two questions regarding their use:1- If I start using them now, what will 'break' that used to work fine before I put them into all my webdna pages?2- isn't there certain times when you cannot use [setmimeheader] tags -- such as on the same page than has [setcookie] or [redirect] or [returnraw] tags in it? If anyone remembers please post your response or email me privately, thanks. Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
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:
using showpage and showcart commands (1996)
EmailProblem vs EmailComplete (2000)
Log-in Scheme (2003)
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
Summing fields (1997)
Supressing Error Messages (1998)
UPDATE PROBLEM (1997)
Banners and sort of random display (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Deleting with contexts (2001)
Setting up WebCatalog with Retail Pro data (1996)
OT: Quick poll (2003)
Adult Hosting (2001)
Webstar 1.3.1 PPC (1997)
[index] (1997)
WCS Newbie question (1997)
Showif for mulitple variations (1997)
problems with 2 tags (1997)
The USArea® Network web site ... (1997)
Intel WebDNA, FYI (2006)