Re: [GENERAL] encoding advice requested

2006-11-14 Thread Martijn van Oosterhout
On Tue, Nov 14, 2006 at 12:01:44AM +0100, Daniel Verite wrote: Also, you'll find this extensively and better explained in this article, for example: http://ppewww.ph.gla.ac.uk/~flavell/charset/form-i18n.html This is a *really* good article about character sets and form submission. Especially

Re: [GENERAL] encoding advice requested

2006-11-13 Thread Albe Laurenz
My database locale is en_US, and by default my databases are UTF8. My application code allows the user to paste text into a box and submit it to the database. Sometimes the pasted text contains non UTF8 characters, typically the fancy forms of quotes and apostrophes. The database does

Re: [GENERAL] encoding advice requested

2006-11-13 Thread Rick Schumeyer
Albe Laurenz wrote: My database locale is en_US, and by default my databases are UTF8. My application code allows the user to paste text into a box and submit it to the database. Sometimes the pasted text contains non UTF8 characters, typically the fancy forms of quotes and

Re: [GENERAL] encoding advice requested

2006-11-13 Thread Marcus Engene
Rick Schumeyer skrev: I will have to try the WIN1252 encoding. On the client side, my application is a web browser. On the server side, it is php scripts on a linux box. The data comes from copying data from a browser window (pointing to another web site) and pasting it into an html

Re: [GENERAL] encoding advice requested

2006-11-13 Thread Daniel Verite
Rick Schumeyer wrote: I will have to try the WIN1252 encoding. On the client side, my application is a web browser. On the server side, it is php scripts on a linux box. The data comes from copying data from a browser window (pointing to another web site) and pasting it into

Re: [GENERAL] encoding advice requested

2006-11-12 Thread Shoaib Mir
Using the convert function might be of help here as well:convert(string using conversion_name)Change encoding using specified conversion name. Conversions can be defined by CREATE CONVERSION. Also there are some pre-defined conversion names (

Re: [GENERAL] encoding advice requested

2006-11-12 Thread Daniel Verite
Rick Schumeyer wrote: My database locale is en_US, and by default my databases are UTF8. My application code allows the user to paste text into a box and submit it to the database. Sometimes the pasted text contains non UTF8 characters, typically the fancy forms of quotes and

[GENERAL] encoding advice requested

2006-11-11 Thread Rick Schumeyer
My database locale is en_US, and by default my databases are UTF8. My application code allows the user to paste text into a box and submit it to the database. Sometimes the pasted text contains non UTF8 characters, typically the fancy forms of quotes and apostrophes. The database does not

Re: [GENERAL] encoding advice requested

2006-11-11 Thread Martijn van Oosterhout
On Sat, Nov 11, 2006 at 02:45:00PM -0500, Rick Schumeyer wrote: My database locale is en_US, and by default my databases are UTF8. My application code allows the user to paste text into a box and submit it to the database. Sometimes the pasted text contains non UTF8 characters, typically