Re: [WebDNA] Foreign characters (2009)
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102310
interpreted = N
texte = --Apple-Mail-17-364169963Content-Type: text/plain;charset=ISO-8859-1;format=flowed;delsp=yesContent-Transfer-Encoding: quoted-printableExcept for any circumstances where the definition of otherwise =20identical words changes with character decorations. Are there any =20(especially hilarious) examples of this?PatOn Mar 31, 2009, at 11:17 AM, Donovan Brooke wrote:> christophe.billiottet@webdna.us wrote:>> I guess it will depend on your encoding, but a table like this =20>> should help:>> [table name=3Dt1&fields=3Dfrom,to]>> =E9 e>> =E8 e>> =EA e>> =EB e>> =FB u>> =F9 u>> =FC u>> =EE i>> =ED i>> =EF i>> =F3 o>> =FC u>> =DA U>> =D3 O>> =CD I>> =F1 n>> =D1 N>> =C9 E>> =C8 E>> =E7 c>> =E0 a>> =C1 A>> =E0 a>> =E1 a>> =CA E>> =C0 A>> [/table]>> Then, when you search your caf=E9, [Search db=3Dbase.db&woNAMEdata=3Dca=f=E9 =20>> [convertchars table=3Dt1]caf=E9[/convertchars]]....>> It will search for "caf=E9" or "cafe">> - chris>>> That may be a good approach, but in the posters example, it was> the other way around. So, you'd have to switch the characters..> from
to> A=C0>> for example.>> It would depend on what format your data was in as to which> "way" the conversion should take place... but I like the> solution Chris!>> Donovan>>>> --=20> Donovan D. Brooke PH: 1 (608) 770-3822> ------------------------------------------------> VP> WebDNA Software Corporation> 16192 Coastal Highway> Lewes, DE 19958> ---------------------------------------------------------> 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/--Apple-Mail-17-364169963Content-Disposition: attachment;filename=smime.p7sContent-Type: application/pkcs7-signature;name=smime.p7sContent-Transfer-Encoding: base64MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGGTCCAtIwggI7oAMCAQICEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDkyNzAxMTg1M1oXDTA5MDkyNzAxMTg1M1owPjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEbMBkGCSqGSIb3DQEJARYMcG1Ad2ViZG5hLnVzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtb7ZYYJV7sbgqxdgpBU/qCRsIJYGNIo40L9odKmo6Y/mPBybeSry8KefqmuWoBXxc6xCvSSJDWFcb2sZ+TkedZrdxvtoL1pHNjDZNe2ow+RCNUvJcQd1+ASzh0J4QLHnNyoMY3zuCQwqM6hK5gU4AlpOSITekksSFuGXBdJTjSeIgIpZFTTrd1c/Zv7miT9gO5UmHiyDClKP8oX31YFlb3q9EM2p8WQzb2Ce2M9kokCs8ZnhT+fRNc/Q9lc4RJtEuf3zynvg0cCbf71pgoC0Zepsop466jrvc08MsxxzRJDmjw20ci/3ltk+iAcD3TchYppwyX4HZhjrrZXcOMBMkQIDAQABoykwJzAXBgNVHREEEDAOgQxwbUB3ZWJkbmEudXMwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQUFAAOBgQCBMxqOGsLwOxtLQ8YLvOQOym8UQyB0CiF0Dpd0oOA+hjD5n9A1eileTd8OdkdPIb+der2Kw42N/UKARNSSkmn1hhKrgwTNYLyXFNlB+TJ2YvG13B27d4EaUdSn2KWKDKG4w14lQSO9y+RTjMSuYi4kbeI50QHLZsTZDO3OhNcKjzCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQGa+8CDkvo9yUTyu7Cj+AxjAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wOTAzMzExNjI4MTFaMCMGCSqGSIb3DQEJBDEWBBR6WFS0LqnHahYe3KGq42ZJP8gYpTCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqGSIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAQ0fpGJFe+c0k63B+7o5JWTkqXA3mJo1aWGYnXlkxL0Ec34xsPncPQ+FRdFC9TYWOtjV88+mdv1BhsawtEk+njlW/JMeRfNSnUNqk8BgtM+SN3qJNGNIZBlImZB9SwsKN7XeQnAvk56MdDKxqFZjv6JWzPLkLvvUYN6yrn5JbH4U/95T8Y34+IO7lgk9uiST6Sf4lbrKrDqAeQJu325LKkMe7DsT11Mu8JnoW73Uo675ZCUzKoiKnDm+RKR8LmbK23qAbQ9dNu2LZWhoYy676P1BpNy+TaWcrmn0A6y3LxxfWvwpkeyNf5AA5QVh0jjNIugADBwAtXXNi8PGQ9Z6PIQAAAAAAAA==--Apple-Mail-17-364169963--
Associated Messages, from the most recent to the oldest:
--Apple-Mail-17-364169963Content-Type: text/plain;charset=ISO-8859-1;format=flowed;delsp=yesContent-Transfer-Encoding: quoted-printableExcept for any circumstances where the definition of otherwise =20identical words changes with character decorations. Are there any =20(especially hilarious) examples of this?PatOn Mar 31, 2009, at 11:17 AM, Donovan Brooke wrote:> christophe.billiottet@webdna.us wrote:>> I guess it will depend on your encoding, but a table like this =20>> should help:>> [table name=3Dt1&fields=3Dfrom,to]>> =E9 e>> =E8 e>> =EA e>> =EB e>> =FB u>> =F9 u>> =FC u>> =EE i>> =ED i>> =EF i>> =F3 o>> =FC u>> =DA U>> =D3 O>> =CD I>> =F1 n>> =D1 N>> =C9 E>> =C8 E>> =E7 c>> =E0 a>> =C1 A>> =E0 a>> =E1 a>> =CA E>> =C0 A>> [/table]>> Then, when you search your caf=E9, [Search db=3Dbase.db&woNAMEdata=3Dca=f=E9 =20>> [convertchars table=3Dt1]caf=E9[/convertchars]]....>> It will search for "caf=E9" or "cafe">> - chris>>> That may be a good approach, but in the posters example, it was> the other way around. So, you'd have to switch the characters..> fromto> A=C0>> for example.>> It would depend on what format your data was in as to which> "way" the conversion should take place... but I like the> solution Chris!>> Donovan>>>> --=20> Donovan D. Brooke PH: 1 (608) 770-3822> ------------------------------------------------> VP> WebDNA Software Corporation> 16192 Coastal Highway> Lewes, DE 19958> ---------------------------------------------------------> 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/--Apple-Mail-17-364169963Content-Disposition: attachment;filename=smime.p7sContent-Type: application/pkcs7-signature;name=smime.p7sContent-Transfer-Encoding: base64MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGGTCCAtIwggI7oAMCAQICEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDkyNzAxMTg1M1oXDTA5MDkyNzAxMTg1M1owPjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEbMBkGCSqGSIb3DQEJARYMcG1Ad2ViZG5hLnVzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtb7ZYYJV7sbgqxdgpBU/qCRsIJYGNIo40L9odKmo6Y/mPBybeSry8KefqmuWoBXxc6xCvSSJDWFcb2sZ+TkedZrdxvtoL1pHNjDZNe2ow+RCNUvJcQd1+ASzh0J4QLHnNyoMY3zuCQwqM6hK5gU4AlpOSITekksSFuGXBdJTjSeIgIpZFTTrd1c/Zv7miT9gO5UmHiyDClKP8oX31YFlb3q9EM2p8WQzb2Ce2M9kokCs8ZnhT+fRNc/Q9lc4RJtEuf3zynvg0cCbf71pgoC0Zepsop466jrvc08MsxxzRJDmjw20ci/3ltk+iAcD3TchYppwyX4HZhjrrZXcOMBMkQIDAQABoykwJzAXBgNVHREEEDAOgQxwbUB3ZWJkbmEudXMwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQUFAAOBgQCBMxqOGsLwOxtLQ8YLvOQOym8UQyB0CiF0Dpd0oOA+hjD5n9A1eileTd8OdkdPIb+der2Kw42N/UKARNSSkmn1hhKrgwTNYLyXFNlB+TJ2YvG13B27d4EaUdSn2KWKDKG4w14lQSO9y+RTjMSuYi4kbeI50QHLZsTZDO3OhNcKjzCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQGa+8CDkvo9yUTyu7Cj+AxjAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wOTAzMzExNjI4MTFaMCMGCSqGSIb3DQEJBDEWBBR6WFS0LqnHahYe3KGq42ZJP8gYpTCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqGSIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAQ0fpGJFe+c0k63B+7o5JWTkqXA3mJo1aWGYnXlkxL0Ec34xsPncPQ+FRdFC9TYWOtjV88+mdv1BhsawtEk+njlW/JMeRfNSnUNqk8BgtM+SN3qJNGNIZBlImZB9SwsKN7XeQnAvk56MdDKxqFZjv6JWzPLkLvvUYN6yrn5JbH4U/95T8Y34+IO7lgk9uiST6Sf4lbrKrDqAeQJu325LKkMe7DsT11Mu8JnoW73Uo675ZCUzKoiKnDm+RKR8LmbK23qAbQ9dNu2LZWhoYy676P1BpNy+TaWcrmn0A6y3LxxfWvwpkeyNf5AA5QVh0jjNIugADBwAtXXNi8PGQ9Z6PIQAAAAAAAA==--Apple-Mail-17-364169963--
Patrick McCormick
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:
Timer Values on [redirect] (1998)
[WriteFile] problems (1997)
Re:quit command on NT (1997)
GuestBook example (1997)
[isfolder] and [filename] (1997)
protect tag on NT IIS (1997)
expired beta (1997)
Need help with form (1998)
Pithy questions on webcommerce & siteedit (1997)
search between two dates (2003)
Bug when including a db file ... ? (2000)
Performance Issue (2000)
Expected Behavior? (1999)
Accented chars and emailer (1998)
Cart# (1997)
Creating a folder with WebCat? (2000)
WebCat editing, SiteGuard & SiteEdit (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Authenticate (1999)
Limitations on fields? Server is crashing (1997)