I hate it when the CGI transaction clobbers characters. You can set the content-encoding in the HTML to UTF-8, and it might help, but I think the conversion from the urlencoded value is dependent on the web server platform's encoding (OS codepage, app platform settings, etc.)
Plus, you run the risk of a user forcing the browser's encoding to something other than what you intended. -Clark ----- Original Message ---- From: P Kishor <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, April 5, 2007 7:39:33 AM Subject: [sqlite] storing funky text in TEXT field Seems like a basic question, but I can't figure out a definitive answer to this. I want to store UTF-8 characters in a TEXT field, y'know, things like umlauts and accents and that Norwegian slashed-O thingy, perhaps even South Asian Devnagari. The documentation says about text -- "TEXT. The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16-LE)." So, what do I do? Do I have to declare the database encoding while creating the database? I find that if I update the database table via a web-form, these funky characters get clobbered. Is this something that I have to account for in my web application? How? Many thanks in advance. -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
